when sb uses the temp table,how to get the exec plan just like select * from h.tb_fund l,session.test_fund r where l.account=r.account; anybody can help me? DB2 & UDB email list listserv db2-l LazyDBA home page