I have a database that has several tables that are all linked with a relationship on a field that contains a unique numeric ID. I need to run a query that pulls data from two of the tables and all attempts so far are not giving me the output that I need.
Table A has several fields including the unique ID and has over 1000 records in it. Table B has about 5 fields one of which is the unique ID. Table B only has about 500 records, not all the unique IDs from Table A are in Table B.
I would like my query to give me a listing of all 1000+ records from Table A and one or two of the fields from Table B, but if the unique ID isn’t in Table B those fields would just be blank.
The query that I have is only matching the 500 records that match up between the tables and is not reporting the rest of the Unique IDs from Table A. Basically if the Unique ID is not in Table B I need to know which one. I could compare the two and figure it out manually, but I need it to be dynamic as I make changes to Table B.
Any help is greatly appreciated.
