How to use the WITH clause

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 Received on Wed Jul 09 2003 - 20:14:16 CDT