Skip to Content
0
Former Member
May 15, 2008 at 01:43 PM

Syntax error regarding table

222 Views

Hi Gurus,

I am working on a select statement, initially I have wriiten a select statement using the inner joins but then we had some performance issues and I have advised not to use joins...and after that I have written the following statement:

select:

mara~matnr

mara~means

mara~mtart

marc~werks

mard~lgort

from

mara as mara,

mard as mard,

marc as marc

where

(maramatnr = mardmatnr) and (marcmatnr = mardmatnr) and (marcwerks = mardwerks).

but when I am executing this stattement it's iving me an error :

Wrong table name or table alias name table alias name "VBSEGS". table

can you please tell me how make it right