inner join query

[danarashad]

can you do an inner join and use and or statement.
example
SELECT distinct table1.colors, table1.colors2, table2.rec_ID, table2.keyName, table2.form_id, table2.teacherID as sid, table2.teacherStatus, table2.teacherStatus, table2.appraiserStatus, table2.appraiserStatus, table2.cycleYear as ty, table2.cycle as tdc, table2.saved, table2.status
FROM table2 INNER JOIN table1 ON table2.status = table1.colors or table2.status=table1.colors2 where teacherStatus = 2 and appraiserStatus = 1 and teacherID=#ID#

how do i group the or clauses together
(table2.status = table1.colors or table2.status=table1.colors2)
Is that correct.
thanks in advanced.

 

[PHV]

You may also try this:
FROM table2 INNER JOIN table1 ON table2.status IN (table1.colors,table1.colors2)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886