Re: q:Subqueries
From: Poornima Mohanbapu <pmohanba_at_qntm.com>
Date: 1995/08/24
Message-ID: <41i94q$g2s_at_worf.qntm.com>#1/1
Date: 1995/08/24
Message-ID: <41i94q$g2s_at_worf.qntm.com>#1/1
>I am trying to do an insert using a subquery i.e.
>
>INSERT INTO table1 (field1, field2)
>SELECT field3, field 4
>FROM table2
>
>The problem is as follows. I would like to ORDER BY field3 but one cannot
>use the ORDER BY clause in a subquery according to the manual.
Why do you need to do the order by. Regardless of which order the data is inserted into table1, when selecting from that table, you can order by the desired field - in this case field1.
Poornima. Received on Thu Aug 24 1995 - 00:00:00 CEST