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
 )

显示全文