Re: How to Create Local Temporary Table

The query is part of procedure :

SELECT xxx
FROM (subquery) a,

   (
   SELECT xxx
   FROM hms_tpo_lp_plant a,(subquery) b
   WHERE [clause]
   ) b
WHERE [clause]

Where first subquery and second subquery are the the same. The subquery only access 1 table with where clause that use parameters. So what should I use to replace subquery??

Thanks Received on Fri Apr 21 2006 - 02:59:06 CDT