HELP SQL+WHERE+UNION QUERY+Duplicate Entries

mercredi 1 avril 2015

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 tables. They all work until incorporated into a UNION QUERY.



Question, is there another way to structure the "WHERE" statement for this UNION Query and achieve the same results?



Thank you for your time.




HELP SQL+WHERE+UNION QUERY+Duplicate Entries

0 commentaires:

Enregistrer un commentaire

Labels