So here's the scenario, I'm combining two tables to create a third table. They are joined by an ID field.
Sometimes Table B does not have the ID to coincide with Table A, which is fine. The record will still show in the new table, with a blank field from Table B. (inner join)
However, sometimes the ID is missing from Table A, and it is in Table B. (outer join). I need to be able to see these records as well on the final table. But instead the Table A field will be blank.
ID FIELD A
ID FIELD B
In the end I want to see:
ID FIELD A FIELD B
1 Hello The
3 Name Jumped
5 Sam Fence
is this possible, or perhaps I need to do two queries?