Dave Watts wrote: >Generally, in most database environments, you can't specify the same field >twice unless you alias it at least once. If you could do this before, you >shouldn't have been able to. I suspect that the database or driver is >renaming both of the fields for you, to prevent an error from occurring - if >you dump the query, you might be able to see this.
I know you can't specify the same column name twice within the query, unless you specify which table it's from, such as C.Category_ID or Categories.Category_ID. But * is acceptable SQL to get all the columns from all the tables, and M.*,C.* is certainly standard SQL. I've seen it used for years in just about every application I've ever looked at. I've never seen the table name returned as part of the column name. In my case, using M.*,C.* should return the Main_Category_ID from the M. table since it's specified first. Since this is an inner join, they'll be identical anyway. My point is that #Main_Category_ID# should not return an error. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development & Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local & Int'l Phone/Fax: 386.789.0968 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
