fetching data using SQL queries from java dictionary

[Former Member]

hiiii all,

I have a SQL query where am using WHERE clause as a result of which the NULL values are getting filtered...can u please help

me to tranform this query into LEFT OUTER JOINS so as to avoid this filtration....my query is

SELECT A.JOINT_ID,A.SIZE_NBMM,A.ISFIELDJOINT,A.WELDTEST_CRI_ID,C.LINE_ID,D.TESTLEVELNO,E.COMPLETE FROM EALPS_DRWREVSPLJTS

A,EALPS_DRW_REV_SPL B,EALPS_DRW_REV_LINE C,EALPS_WELDTESTCRIT D,EALPS_ACTV_SEQ E WHERE B.SPOOL_ID=A.SPOOL_ID AND

B.LINE_ID=C.LINE_ID AND D.WELD_TEST_CRIT_ID=A.WELDTEST_CRI_ID AND E.ACTIVITY_CODE='VT' AND E.JOINT_ID=A.JOINT_ID

Thanks and Regards,

Parama

[Former Member · Accepted solution]

Hii Sir,

The error am getting with above query is:

The SQL statement "SELECT A.JOINT_ID,A.SIZE_NBMM,A.ISFIELDJOINT,A.WELDTEST_CRI_ID,C.LINE_ID,D.TESTLEVELNO,E.COMPLETE FROM EALPS_DRWREVSPLJTS A left outer join EALPS_DRW_REV_SPL B on A.SPOOL_ID=B.SPOOL_ID left outer join EALPS_DRW_REV_LINE C on B.LINE_ID=C.LINE_ID AND left outer join EALPS_WELDTESTCRIT D on A.WELDTEST_CRI_ID =D.WELD_TEST_CRIT_ID left outer join EALPS_ACTV_SEQ E on A.JOINT_ID=E.JOINT_ID" contains the syntax error[s]: SQL syntax error: "LEFT" is a reserved keyword that was not expected here

Thanks and Regards,

Parama Laha

[Former Member · Accepted solution]

Hey

try below query

SELECT A.JOINT_ID,A.SIZE_NBMM,A.ISFIELDJOINT,A.WELDTEST_CRI_ID,C.LINE_ID,D.TESTLEVELNO,E.COMPLETE FROM EALPS_DRWREVSPLJTS 
A left outer join EALPS_DRW_REV_SPL B on A.SPOOL_ID=B.SPOOL_ID, EALPS_DRW_REV_SPL B1 left outer join EALPS_DRW_REV_LINE C on B1.LINE_ID=C.LINE_ID , EALPS_DRWREVSPLJTS 
A1 left outer join EALPS_WELDTESTCRIT D on A1.WELDTEST_CRI_ID =D.WELD_TEST_CRIT_ID, EALPS_DRWREVSPLJTS 
A2 left outer join EALPS_ACTV_SEQ E on    A2.JOINT_ID=E.JOINT_ID
 

regards

Surender Dahiya

[Former Member · Accepted solution]

I hope the above query works.

regards

Surender Dahiya

[Former Member]

Hi,

I hope this helps

SELECT A.JOINT_ID,A.SIZE_NBMM,A.ISFIELDJOINT,A.WELDTEST_CRI_ID,C.LINE_ID,D.TESTLEVELNO,E.COMPLETE FROM EALPS_DRWREVSPLJTS 
A left outer join EALPS_DRW_REV_SPL B on A.SPOOL_ID=B.SPOOL_ID  left outer join EALPS_DRW_REV_LINE C on B.LINE_ID=C.LINE_ID AND left outer join EALPS_WELDTESTCRIT D on A.WELDTEST_CRI_ID =D.WELD_TEST_CRIT_ID  left outer join EALPS_ACTV_SEQ E on    A.JOINT_ID=E.JOINT_ID

Regards

Surender Dahiya