For most systems, where clause joins are inner joins only (Oracle allows outer joins there and other systems may too).
The other way allows for outer joins and all sorts of other options. It is less limited. On 10/20/05, Mark Fuqua <[EMAIL PROTECTED]> wrote: > 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:221586 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
