D 2012-11-02T15:14:42.502 J +comment \n\n
drh\sadded\son\s2012-11-02\s15:14:42:
\nAn\seven\ssimpler\sdemonstration\sthat\somits\sthe\ssubquery\sin\sthe\sFROM\sclause:\r\n\r\n
\r\nCREATE\sTABLE\st1(id1,\svalue1);\r\nINSERT\sINTO\st1\sVALUES(4469,2),(4469,1);\r\nCREATE\sTABLE\st2\s(value2);\r\nINSERT\sINTO\st2\sVALUES(1);\r\nSELECT\s(SELECT\ssum(value2=value1)\sFROM\st2),\smax(value1)\r\n\s\sFROM\st1\r\n\sGROUP\sBY\sid1;\r\n
K bfbf38e5e9956ac69f9491e5112636ff2ecef923 U drh Z 2e7e79479ef94f66e6f99003810a7a8f