List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:September 24 1999 2:48am
Subject:Re: A Query
View as plain text  
At 19:44, 19990923, Thimble Smith wrote:
>mysql> select b.shopper_id
>    -> from   sale_items b left join sales a
>    ->        on (a.shopper_id = b.shopper_id)
>    -> where  a.shopper_id is null;
>
>That will find any sales that are not paired with a sale_item.

Errr...that will find any sale_items that aren't pared with a sale, I
mean.

Tim
Thread
A QueryChris Lambrou24 Sep
  • Re: A QueryThimble Smith24 Sep
    • Re: A QueryThimble Smith24 Sep
  • Re: A QueryAndrian Pervazov24 Sep