table-or-subquery [图片] 使用者:join-clauseselect-coreselect-stmt 参考:exprjoin-clauseselect-stmt 另见:lang_altertable.htmllang_attach.htmllang_createindex.htmllang_createtable.htmllang_createtrigger.htmllang_createview.htmllang_delete.htmllang_expr.htmllang_insert.htmllang_select.htmllang_update.htmllang_with.htmlpartialindex.html
:compound-select-stmtfactored-select-stmtsimple-select-stmt 参考:exprjoin-clauseresult-columntable-or-subquery
common-table-expressioncreate-table-stmtcreate-trigger-stmtcreate-view-stmtexprinsert-stmtsql-stmttable-or-subquerywith-clause 参考:common-table-expressioncompound-operatorexprjoin-clauseordering-termresult-columntable-or-subquery
join-clause [图片] 使用者:select-coreselect-stmttable-or-subquery 引用:join-constraint连接运算符表或子查询 另见:lang_altertable.htmllang_attach.htmllang_createindex.htmllang_createtable.htmllang_createtrigger.htmllang_createview.htmllang_delete.htmllang_expr.htmllang_insert.htmllang_select.htmllang_update.htmllang_with.htmlpartialindex.html
join-constraint:展示 [图片] join-operator:展示 [图片] ordering-term:展示 [图片] result-column:展示 [图片] table-or-subquery
join-constraint:show [图片] join-operator:show [图片] ordering-term:show [图片] result-column:show [图片] table-or-subquery
例如: $subQuery=(newQuery())->select('COUNT(*)')->from('user');//SELECT`id`,(SELECTCOUNT(*)FROM`user`)AS
SQLITE_OMIT_COMPOUND_SELECT SQLITE_OMIT_EXPLAIN SQLITE_OMIT_FOREIGN_KEY SQLITE_OMIT_PRAGMA SQLITE_OMIT_REINDEX SQLITE_OMIT_SUBQUERY
show [0rxioreo99.gif] ordering-term:show [lt6qlrdlqa.gif] result-column:show [vuwpe53yue.gif] table-or-subquery
:展示 [fzlvittgym.gif] ordering-term:show [6fhi5jebqq.gif] result-column:展示 [dj7lupwx66.gif] table-or-subquery
columnexpression>columnexpression>=columnexpression<columnexpression<=columncolumnIN(expression-list)columnIN(subquery