union query help

[toddbingham]

Whn defining a union query, how can I make it select based on criteria? For Example:

SELECT DISTINCT COMPANY_ID, HOURS_WORKED, CHECK_DATE, EMPLOYEE_TYPE FROM [BANK PAHC]

UNION SELECT DISTINCT COMPANY_ID, HOURS_WORKED, CHECK_DATE, EMPLOYEE_TYPE FROM [NH PAHC]

UNION SELECT DISTINCT COMPANY_ID, HOURS_WORKED, CHECK_DATE, EMPLOYEE_TYPE FROM [RADIO PAHC]

UNION SELECT DISTINCT COMPANY_ID, HOURS_WORKED, CHECK_DATE, EMPLOYEE_TYPE FROM [SERVICE PAHC];

When I select on the EMPLOYEE_TYPE field, I only want it to pull records that are defined with a letter H.

How would I accomplish this?

 

[Dugantrain]

Write a query off of your Union Query and include criteria, I reckon.

 

[Jon K]

Add WHERE EMPLOYEE_TYPE="H" to each SQL statement:-


SELECT DISTINCT COMPANY_ID, HOURS_WORKED, CHECK_DATE, EMPLOYEE_TYPE FROM [BANK PAHC] WHERE EMPLOYEE_TYPE="H"

UNION SELECT DISTINCT COMPANY_ID, HOURS_WORKED, CHECK_DATE, EMPLOYEE_TYPE FROM [NH PAHC] WHERE EMPLOYEE_TYPE="H"

UNION ........