How to reference ALIAS col's in Reports 3.0
From: Ken Halsted <kenman_at_mail.snider.net>
Date: Tue, 12 Oct 1999 08:56:41 -0500
Message-ID: <s06flveuh1s26_at_corp.supernews.com>
I have a main query that uses DECODE to build a column called "ak_amt" and was wondering, how do I reference this alias column name in the WHERE section of the same SELECT statement. I keep getting invalid column name.
Date: Tue, 12 Oct 1999 08:56:41 -0500
Message-ID: <s06flveuh1s26_at_corp.supernews.com>
I have a main query that uses DECODE to build a column called "ak_amt" and was wondering, how do I reference this alias column name in the WHERE section of the same SELECT statement. I keep getting invalid column name.
Please help.
Thanks,
Ken Halsted. Received on Tue Oct 12 1999 - 15:56:41 CEST