The "type" of join is not related to "where" the join takes place.
Personally, I prefer to join the tables in the FROM clause. When you specify the join in the WHERE clause, you mix the join(s) with the filters. This can easily lead to many different types of mistakes because of all the extra code. By joining in the FROM clause, you can easily see how the tables are joined: FROM table1 LEFT OUTER JOIN table2 ON col1 = colA WHERE col2 = 'Mike' Rather than: FROM table1, table2 WHERE col1(*) = colA (not sure if I got the outer join syntax correct) AND col2 = 'Mike' Also, not a very good reason, but most sql query builders use the FROM clause joins. -----Original Message----- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 19, 2005 7:03 PM 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221588 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
