Best way to use OR within query

Transact-SQL
1

Hello all,
I'm attempting to join two tables, and I've already added the ON portion of the join, however, I would also like to add a second join but rather than use AND, I would like to use OR, and I was hoping someone might be able to tell me the best method to use in order to accomplish this. Thank you very much. All help is greatly appreciated.

D.

2

post sample table schema and sample data. or at least mention the column names you are using to join

3

... JOIN ... ON column1 = some_value OR column2 = some_other_value