Hi.
Is there any way to optimise the below code. or can i write a join query for this if yes then how.
SELECT land1
zone1
FROM tzone
INTO CORRESPONDING FIELDS OF TABLE t_land
FOR ALL ENTRIES IN int_delivery
WHERE zone1 = int_delivery-zone1.
IF sy-subrc = 0.
SELECT land1
landx
FROM t005t
INTO CORRESPONDING FIELDS OF TABLE t_landx
FOR ALL ENTRIES IN t_land
WHERE land1 = t_land-land1.
ENDIF.
Thanks
Any help will not go unappreciated..