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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
