To convert the query into ANSI sql standard

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

Other Topics

To convert the query into ANSI sql standard

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-06-12 : 09:53:11

mahesh writes "hello,
anybody please convert the query into ANSI sql standard:

SELECT TABLE1.xyz,TABLE2.abc,
FROM TABLE2 a, TABLE1, TABLE2
WHERE a.pub_id = 3211702 AND ( a.ww IS NULL OR a.ww = 0 )
AND ( TABLE1.deleted IS NULL OR TABLE1.deleted = 0 )
AND TABLE1.gg_id = a.pp_id
AND TABLE1.root_id = 10000546
AND TABLE1.xyz *= TABLE2.xyz
AND TABLE2.publication_id = 3211702
AND ( TABLE2.aa IS NULL OR TABLE2.aa = 0 )
ORDER BY TABLE1.xx, TABLE1.yy,TABLE1.zz

THanks & Regards,
MAhesh Sony"

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2006-06-13 : 08:55:35

select * from table2 a
inner join table1 on x=y
inner join table2 on c=d
where q=w
etc....

try to fill in the blanks for yourself and experience some learning.

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2006-06-13 : 09:42:04

TABLE1.xyz *= TABLE2.xyz
turns into a LEFT OUTER JOIN.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources