UNION query in MS Access

[dgillz]

Anyone know how to do a union query in MS Access? In MS SQL server my syntax would be:

select field1 from table union select field1 from table2

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[dodge20]

Same way.

Dodge20

 

[dgillz]

Where do I do this?

I have 2 link tables, and I need to specify the relationship bewtween them. I have options of equal, not equal, left outer, etc. but no union join.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[lespaul]

You set the relationship in the "Relationship" window, to write the SQL, in the query screen select the SQL view rather than the design grid view.