Union Query from 3 tables?

[Freddie81]

Hi again fellow members



I've got a slight dilemma. My union query works when I combine 2 tables but when I try 3 it doesn't. Could someone please explain to me how to go about using 3 tables in a union query?

[JoeM]

In order for your Union query to work, all the fields you are returning must "line-up" and be the same data type.
Also, look for any errors in the data in the third table you are trying to add. That could cause issues.

If you still cannot figure it out, please post the SQL code you are trying for this Union Query, and maybe some sample data.

[isladogs]

In order for your Union query to work, all the fields you are returning must "line-up" and be the same data type.
Also, look for any errors in the data in the third table you are trying to add. That could cause issues.

If you still cannot figure it out, please post the SQL code you are trying for this Union Query, and maybe some sample data.

To elaborate on Joe's point, you must have the same number of fields with the same datatype for each corresponding fields in the same order
So if the first 2 tables have 6 fields & the third has 5 with a 'missing 4th field', add an empty DUMMY field (e.g. '' AS Dummy) in that position