Amy,
as far as i understand FK [Sold To].[Workbook Cost Objects] has
duplicate record.
Thursday, August 7, 2003, 6:42:27 PM, you wrote:
Amy> How can a left join produce a query longer than the "left" table?
Amy> SELECT [2004_Plan].*, [Sold To].[Sold To]
Amy> FROM 2004_Plan
Amy> LEFT JOIN [Sold To]
Amy> ON [2004_Plan].Plan_Cost_Object = [Sold To].[Workbook Cost Objects]
Amy> 2004_Plan is 384 records long...the query produces 385. ideas? This is driving
me nuts!
Amy> Thanks!
Amy>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
