Join-Statements - 03/26/03 06:22 PM
Hi,
I would like to do the following select statement:
select iasmatfms.material,
iasmatfms.statmatnum,
iasmatx.stext,
iasmatx.ltext
from iasmatx right outer join iasmatfms on iasmatfms.material = iasmatx.material
to have all items listed in both databases, but it doesn't work. I always get an error "Command not properly ended".
What is the reason?
------------------
--
Rgds,
Norbert
I would like to do the following select statement:
select iasmatfms.material,
iasmatfms.statmatnum,
iasmatx.stext,
iasmatx.ltext
from iasmatx right outer join iasmatfms on iasmatfms.material = iasmatx.material
to have all items listed in both databases, but it doesn't work. I always get an error "Command not properly ended".
What is the reason?
------------------
--
Rgds,
Norbert