I'm using MySQL. My simplified join syntax lookis like this:
SELECT tbl1.*, tbl2.name FROM tbl1, tbl2 WHERE tbl1.id = tbl2.id
This won't succeed if there is no matching id row in tbl1 and tbl2. But I would like it to succeed anyhow, returning NULL for tbl2.name where there isn't a matching tbl2.id. Has anyone found a workaround for this problem?
SELECT tbl1.*, tbl2.name FROM tbl1, tbl2 WHERE tbl1.id = tbl2.id
This won't succeed if there is no matching id row in tbl1 and tbl2. But I would like it to succeed anyhow, returning NULL for tbl2.name where there isn't a matching tbl2.id. Has anyone found a workaround for this problem?