> > Is the *= universal syntax (MS SQL, Access, Oracle, MySQL > > ect..?) > > it's my understanding that the *= syntax is legacy syntax; i > believe you'll want ansi syntax to effect compatibility with a > most dbms's: > > SELECT h.id, h.header, l.link, l.link_title > FROM headers h LEFT JOIN links l ON h.id = l.headerid
While you're correct to point out that the *= syntax is not ANSI SQL, I suspect that it's supported by more databases than the ANSI JOIN syntax! We typically use ANSI joins, but I remember an unpleasant occurance porting something from MS T-SQL to Sybase T-SQL, and that version of Sybase didn't support ANSI join syntax. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
