Fully Qualified Query - Resolved

[Phenglai]

Guys,

I am having a problem with a query. I am trying to select a single field from a table using three tables for the criteria.

Here is the query:

SELECT w.warehouse
from warehouse as w, employee as e, department as d
where e.department = 1 and d.warehouse = w.whID

I am using a 1 since I am trying to test the query in the Query Analyzer prior to add it to the code.

Thanks,

Jerel