Where句にWHEN,CASEの書き方
SELECT * FROM table_1 A INNER JOIN table_2 B ON A.column_1 = B.column_1 AND B.column_2 CASE WHEN A.column_3 = *** THEN A.column_2 ELSE A.column_3 END
SELECT * FROM table_1 A INNER JOIN table_2 B ON A.column_1 = B.column_1 AND B.column_2 CASE WHEN A.column_3 = *** THEN A.column_2 ELSE A.column_3 END