SQL里的子查询

COLUMN_NAME FROM TABLE_A WHERE COLUMN_NAME OPERATOR (SELECT COLUMN_NAME FROM FROM TABLE_B WHERE BETWEEN VALUE AND VALUE)

下面这样做是不可以的：
SELECT COLUMN_NAME FROM TABLE_A WHERE COLUMN_NAME  BETWEEN VALUE AND  (SELECT COLUMN_NAME FROM
                                        FROM TABLE_B WHERE CONDITION)

 

SQL里的子查询

标签：column   函数   code   table   style   group by   select   blob   between