SQL Question: Union Query

[mkfloque]

Hello All. I have 6 different queries i need to join. There's only one common field (numerical month) among all the queries.


I'd like all numerical months to fall into a numerical month row (not combine them!). And have all the other fields be separate columns (no combining!).

I'm not sure of the syntax, though.

Any help would be appreciated, thanks

[CJ_London]

not sure what you are asking - each subquery within a union query must return the same number and datatype of columns.

Perhaps provide some example data and an example of the resultant outcome required

[John_G]

You would select all the fields from each table, then use inner joins to link the tables on the month number. An easy way to do this would be to create the query in query builder, then copy the SQL to wherever you need to use it (though it will need some cleaning up to remove CR's).

[aytee111]

Careful of the inner join - all queries MUST then have the same list of months, not always true.