I am trying to join 6 tables and am getting a raiserror. I can join two
tables without any problem, but when I add the third table, I get an error
message. Any help in this matter will be appreciated.
Thanks,
Error Message:
>Warning. Command name: GET DATA
>SQLExecDirect failed :[Sybase][ODBC Driver][Adaptive Server IQ]General
error: RAISERROR executed:
>-- (dfp_Simple.cxx 533)
Syntax:
GET DATA
/TYPE=ODBC
/CONNECT='DSN=huddw_iq12'
/SQL ='SELECT '
' T1.abtid, '
' T1.act_id, '
' T1.case_nbr, '
' T2.case_nbr, '
' T2.fips_cnty_cd, '
' T2.fips_st_cd, '
' T3.case_nbr, '
' T3.fctry_fbrct, '
' T4.case_nbr, '
' T4.dflt_rsn_cd, '
' T4.dt_frclsr_inst, '
' T5.case_nbr, '
' T5.frclsr_cmpltn_dt, '
' T5.frst_unpd_dflt_dt, '
' T6.case_nbr, '
' T6.end_cd '
'FROM ((((dbo.ooe_addi AS T1 '
' LEFT OUTER JOIN dbo.idb_1 AS T2 '
' ON T1.case_nbr = T2.case_nbr)
' JOIN dbo.idb_2 AS T3 '
' ON T1.case_nbr = T3.case_nbr) '
' JOIN dbo.claims_form_a AS T4 '
' ON T1.case_nbr = T4.case_nbr) '
' JOIN dbo.sfdw_default_current_detail AS T5 '
' ON T1.case_nbr = T5.case_nbr) '
' JOIN dbo.default_episodes AS T6 '
' ON T1.case_nbr = T5.case_nbr '
.
CACHE.
EXECUTE.
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
