SQL Help

[djumaka]

Hi wizards!
I need your help. I've got a table and in two of its fields are stored pointers to one and the same other table. But!!! How to make the SQL query if I want to show information from the second table if both fields point to different row!
table1[pointer_to_id1,pointer_to_id1]
table2[id,name]

if the pointer_to_id1 points to line 7 the name on line 7 should appear in the first column if pointer_to_id2 points to line 3 the name there should appear in the 2nd column.

The one who help me gets an online beer from me.
Bob.

P.S.:If it is usefull info I use PHP.

[Anon]

if I understand you correctly, you need two instances of table2, like this

select t2a.name,
t2b.name
from table2 t2a,
table2 t2b,
table1
where t2a.id = table1.pointer_to_id1
and table1.pointer_to_id2 = t2b.id