Posted by Jaak on 01/08/06 06:15

Please can somebody help me with this though query

I have 2 fields in my table: owner and machine
none of them are unique

I want to do a query - as input I have a list of owners
as output I need the machines, but only one

jack radio
jack computer
jack cdplayer
bill radio
bill shoes
larry shoes
larry trouser
larry gps
kate cdplayer
kate car

as input I give 'jack AND bill AND larry'
as output I need 'radio computer cdplayer shoes trouser gps'

Can anybody help me?

[Back to original message]