> I had the same problem when I started using the Native Sybase > drivers; they didn't like "INNER JOIN", either. You may end up > having to code your queries old-skool: > > SELECT table1.*, table2.something > FROM table1, table2 > WHERE (table2.key1 = table1.key1) > AND (table1.id = #somevalue#) > > Also, there is a different syntax for LEFT/RIGHT OUTER JOINs: > > SELECT table1.*, table2.something > FROM table1, table2 > WHERE (table2.key1 *= table1.key1) > AND (table1.id = #somevalue#) > > That's a LEFT. A RIGHT is the same, but with a '=*' instead.
Nyuk, nyuk, nyuk. We ran into the same issue several years back, with a project developed first on MS SQL Server using ANSI joins, then ported to Sybase - we had to rewrite about 300 SPs! Oof! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
