-
Adding missing rows in table in 1 select (+ join) command
Hi all! Here's what I need to do :
I have two tables :
A B
a b c d
---- ----
1 z 1 k
2 x 5 l
3 c 6 j
I need a SELECT with JOIN that would give me :
A
a b
----
1 z
2 x
3 c
5 NULL
6 NULL
so I need to add the missing rows from the A.a and B.c JOIN,
how can I do that ?
I can't use a UNION because I can't use MySQL version 4.
Thanks,
Simon
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|