SELECT statement mode

The SELECT command is actually very simple and often used, but code reading is often plagued by coder; in fact, writing in a standard format can reduce the intensity of troubles without SELECTfield1, field2 ,... FROMtable1aJOINtable2bon11ANDjoin_condition1ANDjoin_condition2 .. WHERE11ANDfilter_condition1A

The SELECT command is actually very simple and often used, but code reading is often plagued by coder; in fact, writing in a standard format can reduce the intensity of the trouble without the SELECT field1, field2 ,... FROM table1 aJOIN table2 B on 1 = 1 AND join_condition1 AND join_condition2 .. WHERE 1 = 1AND filter_condition1A

The SELECT command is actually very simple and often used, but reading the code often causes coder troubles;
In fact, writing in a standard format can reduce the intensity of troubles <无>

SELECT    field1,    field2,    ...FROM table1 aJOIN table2 b on 1=1    AND join_condition1    AND join_condition2..WHERE 1=1AND filter_condition1AND filter_condition1AND (1=2    or filter_condition_sub1    or filter_condition_sub2    )