I agree. The example below does not seem to fit in the ScalarSubquery section. Perhaps a doc defect can be filed to relocate this example to the appropriate SQL section.
Regards, Yip Ng On 1/12/07, TomohitoNakayama <[EMAIL PROTECTED]> wrote:
Hello. I 'm translating Derby Reference Manual into Japanese now. // This is very amount of work and need much of time ..... Through the work, I found questionable information in description for ScalarSubquery ( http://db.apache.org/derby/docs/dev/ref/rrefscalarsubquery.html ). In this page, I found next example. -- Introduce a way of "generating" new data values, -- using a query which selects from a VALUES clause (which is an -- alternate form of a fullselect). -- This query shows how a table can be derived called "X" having -- 2 columns "R1" and "R2" and 1 row of data. SELECT R1,R2 FROM (VALUES('GROUP 1','GROUP 2')) AS X(R1,R2) I think this is not ScalarSubquery because the result have two columns. I wonder why this example is written there . Does anyone know reason for this example in ScalarSubquery ? Best regards. -- /* Tomohito Nakayama [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Naka http://www5.ocn.ne.jp/~tomohito/TopPage.html */
