On 12/2/09 11:13 AM, "David Shere" <dsh...@steelerubber.com> wrote:

> Tom Worster wrote:
>> how about using LEFT JOIN:
>> 
>> SELECT ...
>> FROM listings a
>> LEFT JOIN Transactions b ON b.PartNumber = a.PartNumber
> 
> This gives me a result set of 456,567 lines.  I'm looking for a result
> set of 60-70 lines.  (That's how many part numbers we have.)

gosh. unless you have 456,567  listings, i'm not sure how that could happen
other than through a CROSS JOIN or something.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to