Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

What might be wrong with this SQL?

HI I am getting a failed message on Rowset near "ON" any ideas why this would fail? I am running this in a Crystal as a command.

SELECT

IV00101.ITMGEDSC,

IV00101.ITEMDESC,

RM00101.CUSTNAME,

IV40600.UserCatLongDescr,

CATS.UserCatLongDescr,

SOP10200.ITEMNMBR,

SOP10200.SOPNUMBE,

SOP10200.QUANTITY,

SOP10200.OXTNDPRC,

SOP10200.SOPTYPE,

SOP10100.DOCDATE,

'Current' as source

FROM

PBS.dbo.SOP10100 SOP10100 ON

(SOP10200.SOPTYPE=SOP10100.SOPTYPE) AND

(SOP10200.SOPNUMBE=SOP10100.SOPNUMBE)

INNER JOIN

PBS.dbo.IV00101 IV00101 ON

SOP10200.ITEMNMBR=IV00101.ITEMNMBR

INNER JOIN

PBS.dbo.RM00101 RM00101 ON

SOP10100.CUSTNMBR=RM00101.CUSTNMBR

LEFT OUTER JOIN

PBS.dbo.IV40600 IV40600 ON

IV00101.ITMGEDSC=IV40600.USCATVAL

LEFT OUTER JOIN

PBS.dbo.IV40600 CATS ON

IV00101.USCATVLS_2=CATS.USCATVAL

UNION

SELECT

IV00101.ITMGEDSC,

IV00101.ITEMDESC,

RM00101.CUSTNAME,

IV40600.UserCatLongDescr,

CATS.UserCatLongDescr,

SOP10200.ITEMNMBR,

SOP10200.SOPNUMBE,

SOP10200.QUANTITY,

SOP10200.OXTNDPRC,

SOP10200.SOPTYPE,

SOP10100.DOCDATE,

'History' as source

FROM

PBS.dbo.SOP30200 SOP30200 ON

(SOP30300.SOPTYPE=SOP30200.SOPTYPE) AND

(SOP30300.SOPNUMBE=SOP30200.SOPNUMBE)

INNER JOIN

PBS.dbo.IV00101 IV00101 ON

SOP30300.ITEMNMBR=IV00101.ITEMNMBR

INNER JOIN

PBS.dbo.RM00101 RM00101 ON

SOP30200.CUSTNMBR=RM00101.CUSTNMBR

LEFT OUTER JOIN

PBS.dbo.IV40600 IV40600 ON

IV00101.ITMGEDSC=IV40600.USCATVAL

LEFT OUTER JOIN

PBS.dbo.IV40600 CATS ON

IV00101.USCATVLS_2=CATS.USCATVAL

Not what you were looking for? View more on this topic or Ask a question