NO!!!!!! There are awful table aliases which mean nothing. It is just plain ugly to abbreaviate them like this... at the very least you should qualify the name in some way....table a, b,c and d is just lazy.
-----Original Message----- From: Matt Friedman [mailto:[EMAIL PROTECTED] Sent: 09 May 2005 15:10 To: CF-Talk Subject: Re: More than one datasource in <cfquery> A great trick in MS SQL that will solve your issue is to use this format select a.col1,a.col2, b.col1,b.col2 from a, <database_name>..b as b where a.col1 = b.col1 The trick is taht the <database_name> is the name in the SQL server not CF admin. that works fine and you can link as many database as you wish. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206055 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
