select single with join

Hi

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

the format of ( vbak_{vbeln eq lips}vgbel ) is not correct. It is problem with ( ) and space.

select single lips_{vbeln vbak}kunnr

from lips

inner join vbak

on ( vbak_{vbeln eq lips}vgbel )

into (lips-vbeln,vbak-kunnr)

where lips~vbeln eq likp-vbeln.

Regards

Thiru.