Skip to Content
0
Former Member
Nov 15, 2005 at 11:46 AM

join between tables

48 Views

what is wrong :

SELECT viser02~sdaufnr

FROM (viser02 INNER JOIN vbak

ON vbakvbeln = viser02sdaufnr

AND vbakposnr = viser02posnr

INNER JOIN vbap

ON vbapvbeln = viser02sdaufnr

AND vbapposnr = viser02posnr)

where vbak~auart = 'WV'

and ( vbap~sobkz <> 'V'

OR vbap~sobkz <> 'W' ).