sql query to filter based on project number

hello All

I figure it would be best to post here, 

I have an Area with a property to capture the project number.

I have a table into which I have an attribute to capture the discipline detail

Lastly I have a third table for my Documents Attributes having the Discipline. 

For that table, I have Define Document Code.

What would be the SQL query to have all the disciplines being listed under the discipline field locate under the Document Attributes table?

I believe the SQL query should  SELECT PW_CODE, PW_DESCRIPTION FROM  (TABLE NAME) WHERE PW_PROJECT=......

..... This is where i'm not sure how to create  that WHERE syntax so the project list under the discipline table should equal the project number under the Area property.

Ultimately I would like to add a second filter or third filter to the WHERE.    Something like  WHERE A = X and/or = Y and/or = Z

In my example that could translate something like.......  WHERE  PW_PROJECT  = project number under the area property AND/OR = PW_FILTER AND/OR = PW_ZONE