Re: Running multiple queries in ACS Run SQL Scripts

Peter -

That's what Charles suggested, and it works. I was making it more difficult than it needed to be...

Regards,
Steve Landess
(512) 289-0387

________________________________
Peter wrote:
Seems like you could also simply do

With TEMP1 as
(
Select
IMITM, IMLITM, IMDSC1, IMSTKT, IMSRP1, IMSRP2, IMSRP3, IMSRP4
from BEHPROD.F4101
where IMLITM = '1169091'
)
select * From temp1;


With TEMP2 as
(Select IBITM, IBMCU, IBLITM, IBSTKT, IBSRP1, IBSRP2, IBSRP3, IBSRP4
from BEHPROD.F4102
where IBLITM = '1169091'
)
select * From temp2;

With TEMP3 as
(
select LIITM, LIMCU, IMLITM, LIPQOH
from BEHPROD.F41021
join BEHPROD.F4101
on LIITM = IMITM
where IMLITM = '1169091'
)
select * From temp3;