help with converting SQL

From: Lance Prais <lprais_at_ts.checkpoint.com>
Date: Thu, 10 Jan 2002 17:05:55 -0800
Message-ID: <F001.003ED45C.20020110163526@fatcity.com>

Does anyone know how to convert this to PL SQL. I need to convert it so I can play with the enjoins and make it work.

SELECT

  PRIMUS_PT_SOLUTION.PC_SOLUTION_ID,
  PRIMUS_PT_SOLUTION_EVENT.PC_SESSION_USER_NAME,
  PRIMUS_PT_INCIDENTLINK.PC_INCIDENT_ID,
  PRIMUS_PT_INCIDENTLINK.PC_CM_RESOURCE_NAME,
  PRIMUS_PT_SOLUTION_EVENT.PC_DATE,
  PRIMUS_PT_SOLUTION.PC_TITLE INTO Solution_History

FROM
  PRIMUS_PT_INCIDENTLINK INNER JOIN (PRIMUS_PT_SOLUTION INNER JOIN

PRIMUS_PT_SOLUTION_EVENT ON PRIMUS_PT_SOLUTION.PC_SECURE_ID =
PRIMUS_PT_SOLUTION_EVENT.PC_SOL_SECURE_ID) ON
PRIMUS_PT_INCIDENTLINK.PC_SOLUTION_UUID =
PRIMUS_PT_SOLUTION.PC_SOLUTION_UUID

WHERE
  (((PRIMUS_PT_SOLUTION.PC_SOLUTION_ID)='sk4968'));

thank you in advance
Lance

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Lance Prais
  INET: lprais_at_ts.checkpoint.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 10 2002 - 19:05:55 CST