With exceptions, of course, depending on the DB platform.  

M!ke 

-----Original Message-----
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 19, 2005 7:56 PM
To: CF-Talk
Subject: Re: OT Joins

 >>The "type" of join is not related to "where" the join takes place.

Except that the WHERE clause only allows for INNER JOINs, and the FROM
clause can have OUTER, LEFT, RIGHT,  and INNER JOINs.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221596
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

Reply via email to