Union Query on one table

[Wallatrix]

Help! My SQL teacher wants us to use a union to combine information and I am not sure how to go about doing that. The question is: List part number and part description of all parts currently on order, or are in class SG, or both.

[JoeM]

You would typically use a Union Query when combine similar data from two different sources (i.e. tables).
All you do is create a query from one source that returns what you want.
Then do the same in another query from your other source (both queries should be the same structure so all the fields line up).
Then take the SQL code from each query, and combine by sticking the word "UNION" between the two sections of SQL code.

See here for more details: http://office.microsoft.com/en-us/ac...010206109.aspx