Skip to Content
0
Former Member
May 28, 2008 at 09:15 AM

fetching data using SQL queries from java dictionary

44 Views

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