Now...I asked LEFT JOIN with WHERE, now without

[Deryck Henson]

This relates to the earlier posts I made about left joins.  I was shown how
to do it with a where clause, but now how do I do it WITHOUT one?  Like

SELECT * FROM basetable left join 2ndtable on (basetable.*=2ndtable.*)

Something like that...  I need help with this as you can see.

- Deryck H
- http://www.comp-u-exchange.com