Please help with converting SQL [message #37025] |
Thu, 10 January 2002 14:38 |
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 |
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';
|
|
|