> I think that is a limitation of MS SQL Server, I can't find any such > thing in the SQL standard and it works fine for me in PostgreSQL:
a plain jane inner join with identitical columns removed (manually) from the select list is a "natural join" for sql server. SELECT * becomes SELECT table1.a, table1.b, table2.* (where columns a,b are identical in both tables). sql server 2k is "Entry Level SQL-92" if thats the sql standard you are referring to. in defence of sql server though, if you "vaguely" reference (without table prefix) any repeated columns, it will throw an error. but yes, "natural join" would be a welcome enhancement. just curious, how many dbs actually fully support sql-92 or sql-99? does full support imply not using things that aren't part of the standard, if i recall correctly triggers & indexes weren't part sql-92 (and some dbs like ocelot-sql wouldn't support these as a result). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
