Merge 2 tables with conditions

[peeaurjee]

Hi!

I have 2 tables:


Table Users:
ID
Name
Password
Birth


Table Status:
ID
Status


Both tables are related by "ID" field, but both tables have not the
same number of elements


I want to obtain a new table with this structure:


Table Result:
ID
Name
Password
Birth
Status


As I said before both tables have not the same number of elements
(rows) so in my result table, "Status" field should be empty for those
"ID"'s not found in "Status" table.


Example:


Users: 1 2 3
John Mary Peter
1234 3333 3456
5/11/81 9/3/80 7/7/69


Staus: 1 3
CODE1 CODE5


Result: 1 2 3
John Mary Peter
1234 3333 3456
5/11/81 9/3/80 7/7/69
CODE1 (EMPTY) CODE5


Thanks in advance.

[Rabbit]

Do an outer join, either left or right depending on the placement of the tables.

[peeaurjee]

Can you please make your answer a little brief ? Thank You

Do an outer join, either left or right depending on the placement of the tables.

[Rabbit]

Can you please make your answer a little brief ? Thank You

I can't tell if you're being sarcastic or just that you're not fluent in english. Did you want me to go into detail?