Skip to Content
0
Former Member
Sep 28, 2005 at 04:56 PM

Select query doubt ?

27 Views

Hi,

I am using the following select statement inside the loop. But I asked to replace the select statement using Read instead of select. How can I write the following query using read ?

SELECT SINGLE CRHD~ARBPL

FROM AFKO

INNER JOIN V_QAPO ON V_QAPOAUFPL = AFKOAUFPL

INNER JOIN CRHD ON CRHDOBJID = V_QAPOARBID

INTO XARBPL

WHERE AFKO~AUFNR = CAUFVD_TAB-AUFNR

AND V_QAPO~VORNR = IAFVC-VORNR.

Points will be surely awarded.

Thanks,

Tushar.