SELECT 语句模式

来源:这里教程网 时间:2026-02-28 08:34:46 作者:

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
    )

相关推荐