Skip to Content
0
Former Member
Jul 28, 2005 at 03:58 PM

Combining two queries in one..

92 Views

Hi,

Can someone tell me how to combine follwoing two queries in one so that it will increase performance..

SELECT single PLNNR from AFKO

into T1

WHERE AUFNR = '007200000100'.

SELECT single STATU from PLKO

into T2

WHERE PLNNR = T1.