Re: Advanced SQL statements writing
From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Sat, 18 Apr 2009 10:15:07 +0200
Message-ID: <74tggdF150ifdU1_at_mid.individual.net>
Phper wrote:
> How can I achieve this?
The purpose of the SELECT list is to select out the columns. So instead of using * just pick what you need. In order to pick columns from subqueries they need to be named. E.g. SELECT c FROM (SELECT (a + b) AS c FROM T)
Date: Sat, 18 Apr 2009 10:15:07 +0200
Message-ID: <74tggdF150ifdU1_at_mid.individual.net>
Phper wrote:
> How can I achieve this?
The purpose of the SELECT list is to select out the columns. So instead of using * just pick what you need. In order to pick columns from subqueries they need to be named. E.g. SELECT c FROM (SELECT (a + b) AS c FROM T)
Cheers
Serge
-- Serge Rielau DB2 Solutions Development IBM Toronto LabReceived on Sat Apr 18 2009 - 03:15:07 CDT