Skip to Content
0
Former Member
Jul 13, 2007 at 12:25 PM

select single with join

573 Views

Hi

some problem at <b>INTO</b>. Pls can any one suggest something.

the format of ( vbakvbeln eq lipsvgbel ) is not correct. It is problem with ( ) and space.

select single lipsvbeln vbakkunnr

from lips

inner join vbak

on ( vbakvbeln eq lipsvgbel )

into (lips-vbeln,vbak-kunnr)

where lips~vbeln eq likp-vbeln.

Regards

Thiru.