Hello Experts,
I have two queries and I want them in one stored procedure which will give two datasets as results.
Here are my queries
SELECT distinct T.TITRANO, C.CIFN, C.CILN, C.CIPHONE,C.CIEMAIL, C.CICLDATE, D.CLDEANO,D.CLDEPHN, V.VIVVIN, V.VIVYEAR, V.VIVMAKE,V.VIVMODEL from DEV.CLCUSINF C, DEV.CLDEAINF D, DEV.CLVEHINF V, DEV.CLTRAINF T where T.TIVID=V.VIVID and T.TICICID=C.CICID and T.TIDEANO=D.CLDEANO;
select distinct T.TITRANO,L.LIDOT, L.LIAPPNBR,L.LITIRSIZ, L.LITIRDPT, L.LIRR, V.VIVIN from DEV.CLLITINF L, DEV.CLVEHINF V, DEV.CLTRAINF T where T.TILTID=L.LILTID and T.TIVID=L.VID and L.VID=V.VIVID
I want the results of two queries in two different resultsets something like a into two datatables.
Can anyone help me with this?
PS:I tried to Tag MySQL but it is not accepting so I tagged SQL. Actually I want a MySQL.