If you have >1 record in the SoldTo table, it'll return that many rows for that join.
Do this query to find it: Select [Workbook Cost Objects], count([Workbook Cost Objects]) >From [Sold To] Group by [Workbook Cost Objects] Having count([Workbook Cost Objects]) > 1 Oh, and rename your tables to take out spaces. :P Those brackets almost killed me. -----Original Message----- From: Conaway, Amy C [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 10:42 To: SQL Subject: quick question How can a left join produce a query longer than the "left" table? SELECT [2004_Plan].*, [Sold To].[Sold To] FROM 2004_Plan LEFT JOIN [Sold To] ON [2004_Plan].Plan_Cost_Object = [Sold To].[Workbook Cost Objects] 2004_Plan is 384 records long...the query produces 385. ideas? This is driving me nuts! Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
