bob...
your example does not appear to work for me. maybe i'm missing
something? i created two tables simply as:
create table test1 values (id int);
create table test2 values (id int);
and populated them with some matching and non-matching data. however,
when i run the query:
select test1.id, test2.id from test1 left join test2 using id;
i get the following error:
You have an error in your SQL syntax near 'id' at line 1
any ideas?
Bob Hall wrote:
> SELECT table_a.id, table_b.id
> FROM table_a LEFT JOIN table_b USING id;
> would return something like
>
> table_a.id table_b.id
> __________ __________
> a NULL
> b b
> c c
> d NULL
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
