UNION is a select statement
Used to combine records from two queries while excluding any duplicates.
When you compare 2 tables both tables must have the same number of fields, but the fields do not have to have the same datatype.
(Query > SQL Specific > Union)
The only way to work with a union query is in the SQL view
Used to combine records from two queries while including any duplicates
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext