Hi,
I have, three tables (one,two, three) with the rows id/value. id is the
key for all the tables.
with
select value from one where id=xx;
select value from two where id=xx;
select value from three where id=xx;
I can select all values from the tables with the id=xx.
How can I do this with one select statement. Notice, it's possible that
there is an entry for id=xx in table one, but
not in table two, or three. Of course ist's possible that there is only
a value in table three.
The output could be
id one.value two.value three.value
x1 233 2342 NULL
x2 NULL 998 NULL
x3 33 232 23
Clear enough?
Thanks for help
Andre
---------------------------------------------------------------------
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
