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