You are right Joe...
I went the route of union because I assumed Ash wanted records from both
tables. From what I can see, if you join the two tables, you will miss
the records that are unique in the joined table.
So if table 1 has 1 record and table 2 has 3. And you join table 2 to
table 1, your result will only be 1 record.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.