I am teaching myself basic SQL use in CR.  I've managed to create a report that works (Yea!!).  The reason I want to use the SQL query in the first place is this.  I have a parameter {Patient Number} that I want to look in fields from either of two tables.  I've tried several angles with no luck. This is what I want:

SELECT
"Patient_Number",
"patient1_num",
"patient2_num",
"patient3_num"

FROM
"Table 1",
"Table 2"

WHERE

{Patient Number} = "Patient_Number"

So Far it works fine

I want to add: 

OR {Patient Number} = "patient1_num"
OR {Patient Number} = "patient2_num"
OR {Patient Number} = "patient3_num"

I've tried IN and various OR statements, but can't get to only pull those records where the {Patient Number} is in other tables/columns

Can someone show me what I'm missing?