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