SELECT field1, field2, ... FROM table1 a JOIN table2 b on 1=1 AND join_condition1 AND join_condition2 .. WHERE 1=1 AND filter_condition1 AND filter_condition1 AND (1=2 or filter_condition_sub1 or filter_condition_sub2 )登录后复制