Selecting rows from 2 tables

anjanesh · #1 (**permalink**) 02-12-06, 01:40

Code:

SELECT *
FROM `tbl1` t1, `tbl2` t2
WHERE t1.id=56 AND t2.id = 56

I need the values from the tables tbl1, tbl2 where the id is 56.
In tbl2 there may or may not be an id=56 - in that case I would still want the query to return tbl1's row - but that wont happen because of the AND.

So how do I return the row of tbl1 when tbl2 doesnt have such an id ?
I know to get this using 2 queries - Im looking for a single query statement.

Thanks

r937 · #2 (**permalink**) 02-12-06, 08:20

use a LEFT OUTER JOIN

anjanesh · #3 (**permalink**) 02-12-06, 09:56

Couldnt figure out JOINS so far - can you pl give me the example for the above ? The docs has a section on Optimization on JOINS but no example of JOINS usage.

Edit : I got this working with LEFT JOIN alone. Thanks.

Internet Services

Web Development

Digital Marketing

Consumer Tech