From: Date: October 24 2005 3:45pm
Subject: Selecting more than one property (req help)
List-Archive: http://lists.mysql.com/mysql/190751
Message-Id: <70d89b10510240645m6ca40f11t6b57e22f0eb3bbc1@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_7412_24096346.1130161530031"

------=_Part_7412_24096346.1130161530031
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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=3D1 *AND* service_id=3D3

What's the best possible (speed) solution for this - I have a lot of record=
s
to juggle about!

I have tried inner joining it within it's self but this method could get
rather complicated.
I have also tried making a count of service_id's captured and HAVING count
=3D=3D 2 but this query seems slow.

Any suggestions or pointers would be great!

Thanks

Membob

------=_Part_7412_24096346.1130161530031--