@@@@@ Caling SQL Guys Please Help me Out, Small Query lo Help Needed @@@@

[Virat Kohli]

Depending on These Condtions i need to extract the address from the tables


If DATA_SRC_CD = 'MAG'

3.1 Then join where

MED_CLM_LN_SBPNA.AEDW_HLH_EVNT_SK = MED_CLM_LN.AEDW_HLH_EVNT_SK

and

MED_CLM_LN_SBPNA.HLH_EVNT_LN_ID = MED_CLM_LN.HLH_EVNT_LN_ID

and

MED_CLM_LN.AEDW_SPRV_SK = PRV_DATA.AEDW_PRV_SK

3.1.1  Then join to PRV_ADR where PRV_MAP.AEDW_PRV_SK = PRV_ADR.AEDW_PRV_SK

and

and MED_CLM_LN_SBPNA.CLM_LN_SRVC_FROM_DT between (PRV_ADR.RW_EFF_DT and PRV_ADR.RW_EXP_DT)

and

PRV_ADR.ADR_TP_CD = 'PT'

3.1.1.1  Then join to ADDRESS where the PRV_ADR.AEDW_ADR_SK = ADDRESS.AEDW_ADR_SK

and return LN2_ADR

3.1.1.1.1 If not found then retry Step 3.1.1 where the PRV_ADR.ADR_TP_CD = ‘CO’ and re-execute Step 3.1.1.1 

Else move ‘~’




nen rasina query idhi,


select F.LN2_ADR


FROM
DB_SBPNAQ1V.MED_CLM_LN_SBPNA A,
DB_AEDWQ1V.MED_CLM_LN B,
DB_AEDWQ1V.PRV_DATA C,
DB_AEDWQ1V.PRV_ADR D,
DB_AEDWQ1V.PRV_MAP E,
DB_AEDWQ1V.ADDRESS F
where a.AEDW_HLH_EVNT_SK =b.AEDW_HLH_EVNT_SK
AND a.HLH_EVNT_LN_ID=  b.HLH_EVNT_LN_ID
AND B.AEDW_SPRV_SK=C.AEDW_PRV_SK
AND E.AEDW_PRV_SK=D.AEDW_PRV_SK
AND D.AEDW_ADR_SK=F.AEDW_ADR_SK
AND A.DATA_SRC_CD='MAG'
AND (A.CLM_LN_SRVC_FROM_DT between D.RW_EFF_DT and D.RW_EXP_DT)
AND D.ADR_TP_CD='CO'

naku naku no spool space ane error coming....

CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@

P.S: na friend ki ee help kavali, he will reply u with any questions here

thankyou thankyou thankyou thankyou

[spalisetty]

[url=http://forums.teradata.com/forum/general/no-more-spool-error-sel-from-table-sql]http://forums.teradata.com/forum/general/no-more-spool-error-sel-from-table-sql[/url]

[Bondu_Babu]

CITI#H@ CITI#H@ CITI#H@ CITI#H@

[k2s]

sSa_j@il

[Virat Kohli]

CITI#H@ CITI#H@ CITI#H@

[riddle]

CITI#H@ CITI#H@ CITI#H@