Results 1 to 1 of 1
Thread: MySQL Query Join Syntax Question
Mar 13, 2005, 09:38 #1
- Join Date
- Jul 2002
- In the network.
- 0 Post(s)
- 0 Thread(s)
MySQL Query Join / CONCAT Syntax Question
I have a MySQL DB where I have no control over the data.
I would like to do something like the following, but haven't been able to track down the correct syntax (or whether it is possible).
SELECT ..... WHERE tableA.Name = (tableB.lastName, tableB.firstName) ...
EDIT: GOT IT WORKING
SELECT ... WHERE (tableA.Name = CONCAT(tableB.lastName, ", ", tableB.firstName)) ...