SELECT IPD.Task_grp "Task Group", TASK.STARTW "Starting Area", TASK.ENDW "Destination Area", IPD.Nxt_Work_Grp,IPD.Nxt_Work_Area
"Drop Area", IPD.Prty "Priority", IPD.Stat_Code "Status"
FROM int_path_defn IPD,
(SELECT start_curr_work_grp || start_curr_work_area StartW,
start_dest_work_grp ||start_dest_work_area EndW
FROM task_hdr WHERE task_id='332800') TASK WHERE IPD.CURR_WORK_GRP || IPD.Curr_Work_Area=TASK.StartW
AND IPD.Dest_Work_Grp || IPD.Dest_Work_Area=TASK.ENDW
I am getting Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '|'.
Please help what could be the wrong. same query executed successfully in oracle sql developer