Query question

#1 (**permalink**) 02-28-2008, 07:15 AM

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?

#2 (**permalink**) 02-28-2008, 07:15 AM

Jaak,
you can use the keyword distinct in your select. Then you don't get
duplicate data rows.

select distinct owner, maschine from table where owner in
('jack','bill','larry')

or if you only need the maschines

select distinct maschine from table where owner in ('jack','bill','larry')

brgd,
Birthe

Jaak wrote:

> 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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode