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

[ahara]

Hello;

I can't run this query so I offer no guarantees - plus I am not sure what you are after - it looks like you want the warehouse associated with an employee of a particular department....at any rate - no harm in trying:

SELECT w.warehouse
FROM
warehouse w, department d, employee e
WHERE
w.whid = d.warehouse AND
d.deptID = e.department AND
e.department = 1

hope that helps - cheers

[Phenglai]

That is it. I just missed a field.

Thanks so much for your help.

Jerel