Best way to use OR within query

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.


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

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