It depends what your WHERE clause says, but it's probably an inner join... SELECT * FROM a INNER JOIN b ON a.x = b.y
or SELECT * FROM a, b WHERE a.x = b.y In this case above, I'd recommend INNER JOIN as it makes what you're trying to do more explicit for debugging and maintenance purposes. Sometimes you want to select rows where there are missing entries in one table (in this case b) ... SELECT * FROM a LEFT JOIN b ON a.x = b.y That would be harder to write using a WHERE clause. It's worth noting btw that CF query-of-queries doesn't support JOIN syntax -- you need to use the WHERE clause. -----Original Message----- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 1:15 p.m. To: CF-Talk Subject: OT Joins Can anyone explain to me what type of join is created when the join is done with the WHERE clause as opposed to the FROM clause in a sql statement. What are the advantages the joins in the FROM clause. I know it is because I am still very green but I find WHERE clause joins much easier to write. Thanks, Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:221590 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
