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