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
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