Union Query Help

[Caryisms]

How do I write the code in-order to see a particular value in one field?

ie. Select Number Field where number is "1",

 

[jrbarnett]

Select Fieldname
From Tablename
Where Fieldname=1

John

 

[Caryisms]

Thank you John.

How do I join records in a union query that will make two records with an ID in common one record? Thanks!

 

[jrbarnett]

A union query is for joining the results of two select queries together, whether related or not.
The syntax is:

select field1, field2
from table1
where field3 = 1
union
select field4, field5
from table2
where field6 = 2


John