SQL Select Help

[h34rt]

ok, I've got a table that looks like this...

BookedVacations

ClientID | Package | Date | unique

GS | Honalulu | 01/01/99| 1
PS | Someplace | 03/05/03| 2
GS | Hotelian | blah/blah| 3

PS | Random | eh/eh/eh| 4

what I want to do is distinctly select the ClientID where the packages include both honalulu and hotelian. with the data above, only "GS" would be returned because only the clientID of GS went to both honalulu and Hotelian. How would i do this?

oh yea, I forgot, no PHP on this one, just 1 (or a series of) sql statements.
-h34rt

[trex005]

SELECT
BookedVacations1.ClientID
FROM
BookedVacations as BookedVacations1
INNER JOIN
BookedVacations as BookedVacations1 USING (ClientID)
WHERE
BookedVacations1.Package = 'Honalulu'
AND
BookedVacations2.Package = 'Hotelian'
GROUP BY
BookedVacations1.ClientID

This is just off the top of my head... let me know if it solves your problem

[sinbad]

I didn't realize it was the same field. sorry.

[trex005]

no need to appologize! 🙂
Mr HEART? (h34rt) what is the status on this?