It's possible when one row in the 2004_Plan table matches multiple rows in
the [Sold To] table. That is, unless your tables' schemas are joined on
unique columns, in which case I have no idea.
Eric
"Conaway, Amy C" <[EMAIL PROTECTED]>
08/07/2003 11:42 AM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
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
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
