Question About Multiple Conditions

[mr.donaldson]

Is it possible to set multiple conditions across multiple tables using OR in a where clause? For instance, can you run where......(table1 = 'test') or (table2 = pass) or (table2 = "fail) AND (class = 'SQL');

 

[CJ_London]

If you mean field names rather than table names (i.e. table1.field1='test'), the short answer is yes