SELECT 语句模式

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      )