James, Dina is correct - 'LEFT JOIN' is the same as 'LEFT OUTER JOIN' for most RDBMS's. Some will actually require LEFT OUTER JOIN, but I think that's rare these days. The LEFT/LEFT OUTER is more loose - it's like telling the DB:
"give me all the records in the left table, and then if there are any matches in the right table, return a record for those too." To return records that ONLY have a match with the table you're relating, use INNER JOIN, as Dina suggested. This type of join says: "give me only the records from the left table that have a match in the right table" Because you are specifying a contstraint in the where clause, the recordset for each of these would have looked the same in your situation, but it's better form, and probably better performance to use the correct join type in your statement :) Sorry for any confusion. Adam. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4