SQL is this equvelent to a LEFT JoIn?
- by Jim
Is this equvelent to a LEFT JOIN?
select distinct a.name, b.name from tableA a, (select name from tableB) as b
It seems as though there is no link between the two tables.
Is there an easier / more efficient way to write this?