Home » SQL & PL/SQL » SQL & PL/SQL » Please help with converting SQL
Please help with converting SQL [message #37025] Thu, 10 January 2002 14:38 Go to next message
Lance Pris
Messages: 40
Registered: January 2002
Member
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
Re: Please help with converting SQL [message #37036 is a reply to message #37025] Fri, 11 January 2002 02:36 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
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 ,
PRIMUS_PT_SOLUTION_EVENT,
PRIMUS_PT_INCIDENTLINK
WHERE PRIMUS_PT_SOLUTION.PC_SECURE_ID = PRIMUS_PT_SOLUTION_EVENT.PC_SOL_SECURE_ID
ANDPRIMUS_PT_INCIDENTLINK.PC_SOLUTION_UUID = PRIMUS_PT_SOLUTION.PC_SOLUTION_UUID
AND WHERE PRIMUS_PT_SOLUTION.PC_SOLUTION_ID='sk4968';
Previous Topic: Manipulting Files
Next Topic: function-based index disabled
Goto Forum:
  


Current Time: Mon Aug 03 05:16:49 CDT 2020