Selecting more than one property (req help)

Hi all, Can anyone throw some suggestions at me for this problem? | id | model | service_id | ||---|| | 1 | 500 | 1 | | 2 | 500 | 3 | | 3 | 500 | 10 | | 4 | 600 | 1 | From this table i want to extract all distinct models which have service_id=1 *AND* service_id=3 What's

Re: Selecting more than one property (req help)

mem bob [EMAIL PROTECTED] wrote on 10/24/2005 09:45:30 AM: Hi all, Can anyone throw some suggestions at me for this problem? | id | model | service_id | ||---|| | 1 | 500 | 1 | | 2 | 500 | 3 | | 3 | 500 | 10 | | 4 | 600 | 1 | From this table i want to extract

Re: Selecting more than one property (req help)

mem bob wrote: | id | model | service_id | ||---|| | 1 | 500 | 1 | | 2 | 500 | 3 | | 3 | 500 | 10 | | 4 | 600 | 1 | From this table i want to extract all distinct models which have service_id=1 *AND* service_id=3 The JOIN-construction is something like: SELECT `model`