Fetching data from 3 tables

Hi All,

I trying to fetch values from 3 tables and pass the values into an internal table.

Code

SELECT KNA1_{KTOKD KNA1}KUNNR KNB1_{BUKRS KNVV}VKORG KNVV_{VTWEG KNVV}SPART KNVV~LOEVM

INTO

(ITAB-KTOKD,ITAB-KUNNR,ITAB-BUKRS, ITAB-VKORG,ITAB-VTWEG,ITAB-SPART, ITAB-LOEVM)

FROM ( ( KNA1

INNER JOIN KNB1

ON KNA1_{KUNNR = KNB1}KUNNR)

KNA1

INNER JOIN KNVV

ON KNA1_{KUNNR = KNVV}KUNNR ) .

I am getting an error message.

"The Format of the Field Specificatio "KNB1~KUNNR" is not supported.

What is the problem here?

Regards

Aby