title: Join 2 Tables if Value of Foo.Column1 = x and Bar.Columns1 = y
body: <p>how can I make a join on columns that will never have equal values?</p>
  
  <p>Is there a way I Left join 2 tables on [Foo.Column1 = x,y, or z] AND [Bar.Column1 = Q]</p>
  
  <p>I want data in a query from 2 tables that have no equal values but I know that if a value in the first table is any one of 3 different values that it actually is equal to.</p>
  
  <p>So can I join 2 tables where if Foo.Column1 contains a specified value and Bar.Column1 Contains a seperate special value then tell the statement the 2 rows are to be linked =?</p>
  
  <p>No values are in either table the same.</p>