Double key retrieval in a single query

[s91066]

Hallo,
Let's say we have 2 tables (Table1, Table2).
Table 1 has the following structure:
ID (Primary Key, auto increment)
Name
bla,bla,bla

Talbe2:
ID (Primary Key)
TID1 (-->Table1.ID)
TID2 (-->Table1.ID)
Now lets say that the data are:
Table1:
1, Test
2, Test 1
3, Test 2

Table2:
1, 3, 2
2, 1, 2

TID1, TID2 are connected with the ID of Table1.
My question is:
How can I retrieve the Table1.Name from a single sql query thus the results will be:
1, Test 2, Test 1
2, Test, Test 1????

I have tried various compinations but I always have either the Table1.Name for the Table2.TID1 OR the Table2.TID2.
I know that the question is a little bit tricky and not so well structured but it is the best way to say it (sorry!!)

Thanks
Peter

[Anon]

Can you post you query?

[s91066]

Well the 'best' one is:

Select Table1.Name From Table1, Table2 Where Table2.TID1=Table1.ID AND Table2.TID2=Table1.ID Order by Table2.TID1.

With that query I can have them all at once but not on the correct order, thus I cannot seperate them somehow.
Any Ideas?