Not sure how to approach this.
I have a query that is joining 3 tables by a unique field.
tbl_Location (locationID)
tbl_Collections (ID)
tbl_Gear (ID)
There is a one to many from tbl_Location to tbl_Collections
If tbl_Collections ID field exists in tbl_Location show me the locationID and all the tbl_Collections Records.
This works fine BUT
I have a 4th table that has Counts. This table is in the same format as tbl_Collections and also can be joined by ID field.
What i want to do is add these records as results to the query above.
SO if tbl_Collections had 345 records and the 4th table (once joined by ID) had 32 records I want the resulting table to have 377 records.
I have a query that is joining 3 tables by a unique field.
tbl_Location (locationID)
tbl_Collections (ID)
tbl_Gear (ID)
There is a one to many from tbl_Location to tbl_Collections
If tbl_Collections ID field exists in tbl_Location show me the locationID and all the tbl_Collections Records.
This works fine BUT
I have a 4th table that has Counts. This table is in the same format as tbl_Collections and also can be joined by ID field.
What i want to do is add these records as results to the query above.
SO if tbl_Collections had 345 records and the 4th table (once joined by ID) had 32 records I want the resulting table to have 377 records.