Skip to Content
0
Former Member
Jun 08, 2009 at 09:23 AM

logical error in join stmt

33 Views

Hi,

Pls tell me whats wrong with this stmt which is giving null values .

SELECT Aaufnr Bgstri Bgstrs Aautyp Aloekz Akokrs A~abkrs

into corresponding fields of table it_aufk

FROM AUFK AS A

INNER JOIN AFKO AS B

ON Aerdat = Bgstrs

WHERE B~gstrs in s_date

AND A~WERKS = P_IWERK

AND A~AUART = S_AUART.