Re: How to use the WITH clause

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 10 Jul 2003 03:03:52 GMT
Message-ID: <sI4Pa.1845$C64.1157@news02.roc.ny>

"Kin Ng" <kin_ng5_at_yahoo.com> wrote in message news:d5b3f600.0307091714.7da04ed5_at_posting.google.com...
> Can someone tell me what's wrong with my use of the WITH clause?
>
> with summary as
> (
> select brand_code from tblmasters where created_by < sysdate
> )
> select brand_code from summary
>
> I kept getting "SQL statement doesn't return rows" error.
>
> Thanks

nothing wrong with the clause. Though you seem to be using it unnecessarily. What is the *exact* error you are getting. btw: are you getting "no rows selected" .. which is not an error.

Anurag Received on Wed Jul 09 2003 - 22:03:52 CDT