March 2nd, 2017, 07:52 AM
Query with Append of 4th table
Not sure how to approach this.
I have a query that is joining 3 tables by a unique field.
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.
March 18th, 2017, 01:50 AM
That would require a UNION query, not a JOIN. However, doesn't really seem sensible to append aggregate data to raw data.