Recent content by hjcksn

Also, please understand the UNION query was established from four individual select queries that identified duplicate entries from four seperate tables The goal was to combine the individual queries into a UNION query and have all the entries identified in one datasheet. Thank you.

No additonal information, or attachments were noted with your reply.

All the "ORDER BY" statements were removed. I should have kept them out and will do so. However, when the "WHERE" were removed, along with the "ORDER BY" statements, the query then processed. Of course not the data desired but the union query was finally in a state to execute. It was at this...

UNION Query will not execute properly. Remove "WHERE" statement query runs. The WHERE statement is used to locate all duplicate records, based on serial number, in a table. Also, it excludes certain data contained in two of the four tables. There are four separate queries for four separate...