Help with SQL query

[Anon]

Hello,
I'm using a MySQL database with two tables set up like the following:

table1
numbera, numberb

table2
uniqueid, string

The two numbers can be equal or not and match a unique id in table2. Basically what I need is a select statement to return the two strings which match the numbers in table1. I've tried using left joins but can only get it to work with one of the two numbers. Could somebody please tell me the most efficient way to accomplish this?

Thank you in advance.

Russell

[Anon]

select * from table2,table2 where uniqueid=numbera or uniqueid=numberb

[[deleted]]

SELECT string_col
FROM table1, table2
WHERE table1.numbera = table2.uniqueid
OR table1.number = table2.uniqueid;

Or a more complex method that fetches both strings at once:

SELECT t1.string, t2.string
FROM table1, table2 t1, table2 t2
WHERE table1.numbera = t1.id
AND table1.numberb = t2.id

[Anon]

Thank you so much vincent. The second one worked perfectly.

Russell