Distinct SELECT to query multiple table

From: php_Boi <timani27_at_gmail.com>
Date: 16 Jan 2007 22:37:23 -0800
Message-ID: <1169015843.356997.151090@51g2000cwl.googlegroups.com>

Hi have a database with two table. the first table caled dates has a set of codes in a column called tcode(s) in a column that is not unique to allow for repeating entries (yes tables are normalized).
+----------------+----------------+--------------+
| code | startDate | endDate |
+----------------+----------------+--------------+

|XYZ                | 2005-06-07  |2005-10-11 |


+----------------+----------------+--------------+

|XYZ                | 2005-10-07  |2005-12-11 |


+----------------+----------------+--------------+

|ZZZ                | 2005-06-07  |2005-10-11 |


+----------------+----------------+--------------+

i want to select only the distinct codes that match search criteria such as this:
"SELECT DISTINCT code FROM dates WHERE startDate >= '2007-04-07' AND endDate <= '2005-10-11'
 The result is then something like
XYZ,BBC,GED,PQR... >From there i have a second table called tripper
+----------------+----------------+--------------+
| code | name | price |
+----------------+----------------+--------------+

|XYZ                | super-skii     |200             |


+----------------+----------------+--------------+

|XYZ                | desert sun    |10               |


+----------------+----------------+--------------+

|ZZZ                | chicken run  |50               |


+----------------+----------------+--------------+

now ideally for one i could just do this for one code that isnt a problem:
SELECT * FROM tripper WHERE price < 10 AND code LIKE XYZ

So the question is how to go about it when there are multiple codes? an array? i if anyone has any ideas please dont hesitate would be much appreciated.

thanks php_Boi Received on Wed Jan 17 2007 - 00:37:23 CST