maybe like this:
select buyerid from (select buyerid ,sellerid from transation left out
join transation on buyerid=sellerid group by buyerid ,sellerid)
where sellerid is null
2012/8/14 Prakrati Agrawal
> Dear Phil,
>
> Can you be a liitle more specific about using the left outer join?
>
> Tha
maybe like this:
select * from (select buyerid ,sellerid from transation left out join
transation on buyerid=sellerid group by buyerid ,sellerid) where sellerid
is not null
2012/8/14 Prakrati Agrawal
> Dear Phil,
>
> Can you be a liitle more specific about using the left outer join?
>
> Thank
