[RESOLVED] Is this possible?

[gszauer]

I have two tables

Table 1: accessorie
+---------------------------+
| id | name |
+---------------------------+
| All the values |
+---------------------------+

Table 2: association
+---------------------------+
| id | id1 | id2 |
+---------------------------+
| All the values |
+---------------------------+

[Table1 columns: id, name]
[Table2 columns: id, id1, id2]

id (in both tables), id1, and id2 are all integers.
Is there any way to filter the result of table1 by one of the columns of table two?
Something like this:
SELECT FROM accessorie WHERE (id = id1 inside the association table)
and
SELECT FROM accessorie WHERE (id != id1 inside the association table)

Thank you for your time
~Gabor

[laserlight]

You could use a subquery:

SELECT * FROM accessorie WHERE id IN (SELECT id1 FROM association)

You could also use a join, which may be better:

SELECT accessorie.*
FROM accessorie, association
WHERE accessorie.id=association.id1

NB: my join may not be correct, so check for yourself, duh.

[gszauer]

Freakin AWESOME!!!!
THANK YOU SOOOOOO MUCH!!!

[laserlight]

You're welcome 🙂
Remember to mark this thread as resolved (if it is) using the thread tools.

[gszauer]

Resolved!