Resolved: if conditions inside where sql

Question:

select * 
  from table1 t1 
       join table2 t2 on t1.column1=t2.column1
 where t1.column1 between 1 and 10 if t2.column2='value1' 
   and t1.column1 between 11 and 20 if t2.column2='value2'

Answer:

CREATE tABLE table2(column1 int, column2 varchar(10))

INSERT INTO table2 VALUEs(1,’value1′),(2,’value1′),(13,’value2′),(44,’value2′)

CREATE tABLE table1(column1 int)

INSERT INTO table1 VALUES (1),(2),(13),(44)

select * from table1 t1 join table2 t2 on t1.column1=t2.column1 where CASE WHEN t1.column1 between 1 and 10 AND t2.column2 like ‘value1’ THEN TRUE WHEN t1.column1 between 11 and 20 AND t2.column2 like ‘value2’ THEN TRUE ELSE FALSE END

column1 | column1 | column2 ——: | ——: | :—— 1 | 1 | value1 2 | 2 | value1 13 | 13 | value2

If you have better answer, please add a comment about this, thank you!