select single and join

Hi

some problem at INTO. 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

Raj.