Manfred Koizar wrote:
> On Wed, 05 Nov 2003 11:52:30 +0000, John Siggins
> <j-siggins(at)blueyonder(dot)co(dot)uk> wrote:
>
>> select reqitem from lasting
>>group by reqitem having count(reqitem) = 1;
>>
>>But this gives me only reqitem column and I want the rest of the row!
>
>
> SELECT l.*
> FROM lasting AS l INNER JOIN (
> SELECT reqitem FROM lasting
> GROUP BY reqitem HAVING count(reqitem) = 1
> ) AS x ON l.reqitem = x.requitem;
>
> Servus
> Manfred
Thanks v much
This seems to works a treat. Your method and Michael's return the same
no of rows so both methods look good to me.
John