SQL Statement

From: Sal DiStefano <sald_at_interflow.net>
Date: Sat, 29 Aug 1998 08:59:30 -0500
Message-ID: <35e8095c.0@tornado.tcccom.net>

I am New to Oracle SQL and have a question as to how to convert this MSSQL statement to ORACLE.

Any Help Would be appreciated.

SELECT dbo.customer.pkid,"Name" = CASE WhEN ccompany = "" THEN cfirstname + " " + clastname Else ccompany END,

                   dbo.customer.ccity,Vehicle = ( dbo.vehicle.cyear + " " +
dbo.vehicle.cmake + " " + dbo.vehicle.cmodel),
                   dbo.customer.PrevSalesperson
FROM         dbo.vehicle INNER JOIN dbo.customer ON dbo.vehicle.customerpk =

dbo.customer.PkId

WHERE (dbo.customer.salesperson = 20)

ORDER BY dbo.customer.clastname

Thanks in advance

Sal Received on Sat Aug 29 1998 - 08:59:30 CDT