to write long select query??

[HParsew]

hi, i want to write 1 long select query. i have 3 tables : a1 (id,name) , a2(id,name) , a3(a1_id,a2_id). so i give to procedure 2 variables (different a2_id), and i need to

select these a1 which have same a2_id. so 2 diferent a2 may have same a1

example: a1 table:
name id
first 1
second 2
third 3

a2 table looks:
name id
red 2
blue 3
green 4

a3 tables looks
a1_id a2_id
1 2
2 3
2 4
so if i give a2_id = 3(red) and a2_id = 4(blue) results must be a1_id = 2(second)
Please help me folks.
thanx! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[rian]

To retrieve a1_ids for which there exists an a1_a2.a2_id value of 3 AND and an a1_a2.a2_id of 4, try

SELECT a1_id
FROM a1_a2 AS 1
JOIN a1_a2 AS 2 USING (a1_id)
WHERE a2_id=3 OR a2_id=4
HAVING COUNT(a2_id)>0; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --