I would like to return rows, with specific columns, for each individual in
my NAMES table, with address and e-mail if these exist. Thought I had the
syntax down but I'm getting NULL results where I know there is data. I'm
used to using SQL Server shortcut * for outer joins, guess that's catching
MySQL uses the LEFT JOIN, RIGHT JOIN Syntax ...
RTFM: http://www.mysql.com/doc/J/O/JOIN.html
> -Ursprüngliche Nachricht-
> Von: Bruce Stewart [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 16. Juli 2001 11:54
> An: Mysql-Help (E-mail)
> Betreff: Outer join syntax
Hi all,
MySQL doesn't support nested subqueries, I know, and I also understand that
the same results can be achieved through outer joins (Left join, Right join
and WHERE IS [NOT] NULL).
Also, inner joins can be expressed either in the FROM clause or the WHERE
clause.
My question is: Can outer j
