I am attempting to query 3 tables. The topmost table is what I call the Master Table. The other two are the Detail tables. I need to filter the query based on critera from either or all tables to create one recordset.

For instance I want all the records from the Master table that have a value = XX in either of the detail tables AND a value = OO in the Header table.

A secondary question would be...I spend at least 15 hours a week writing complex sql statements. Can anyone recommend a source for advanced sql training, so I can stop wasting so much time on searching help files and trial and error.

Thank you in advance.
Carroll