|
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?
Navigation:
[Reply to this message]
|