Join Help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Join Help

Author

Topic

LM_Release2
Starting Member

4 Posts

Posted - 2006-04-18 : 10:43:39

This Works

SELECT MSAPPL1.APPEAL.COSSN, MSAPPL1.T2CLM.BIC
FROM MSAPPL1.APPEAL INNER JOIN MSAPPL1.T2CLM
ON MSAPPL1.APPEAL.COSSN = MSAPPL1.T2CLM.COSSN

But Im Trying To do This:

SELECT MSAPPL1.APPEAL.COSSN, MSAPPL1.T2CLM.BIC,
MSAPPL1.APPEAL.CCRNT_APL_SW, MSAPPL1.APCLNT.LNM,
MSAPPL1.APCLNT.FNM, MSAPPL1.JURIS.CRNT.OCD,
MSAPPL1.T2CLM.PSTUS_CD, MSAPPL1.APPEAL.APL_RSN_CD,
MSAPPL1.APPLCHAR.PMT_CONTN_CD, MSAPPL1.APLDETN.DCN_DT,
MSAPPL1.APLDETN.DCN_CD, MSAPPL1.UNIT.UNIT_FIRST3
FROM MSAPPL1.APCLNT INNER JOIN MSAPPL1.APPEAL
INNER JOIN MSAPPL1.T2CLM INNER JOIN MSAPPL1.JURIS
INNER JOIN MSAPPL1.APPLCHAR INNER JOIN MSAPPL1.APLDETN
INNER JOIN MSAPPL1.UNIT INNER JOIN MSAPPL1.JURIS
ON MSAPPL1.APCLNT.COSSN = MSAPPL1.APPEAL.COSSN AND
MSAPPL1.APCLNT.COSSN = MSAPPL1.T2CLM.COSSN AND
MSAPPL1.APCLNT.COSSN = MSAPPL1.JURIS.COSSN AND
MSAPPL1.APCLNT.COSSN = MSAPPL1.APLDETN.COSSN AND
MSAPPL1.APCLNT.COSSN = MSAPPL1.UNIT.COSSN AND
MSAPPL1.APCLNT.COSSN = MSAPPL1.APPLCHAR.COSSN

which does not work... do you get what i am trying to do.. The first query i am just getting two columns of info but i need about ten columns of info pulled together from a bunch of different tables.

How should i do this...

Thanks Peoples...

Bex
Aged Yak Warrior

580 Posts

Posted - 2006-04-18 : 11:14:12

SELECT MSAPPL1.APPEAL.COSSN
, MSAPPL1.T2CLM.BIC
, MSAPPL1.APPEAL.CCRNT_APL_SW
, MSAPPL1.APCLNT.LNM
, MSAPPL1.APCLNT.FNM
, MSAPPL1.JURIS.CRNT.OCD
, MSAPPL1.T2CLM.PSTUS_CD
, MSAPPL1.APPEAL.APL_RSN_CD
, MSAPPL1.APPLCHAR.PMT_CONTN_CD
, MSAPPL1.APLDETN.DCN_DT
, MSAPPL1.APLDETN.DCN_CD
, MSAPPL1.UNIT.UNIT_FIRST3
FROM MSAPPL1.APCLNT
INNER JOIN MSAPPL1.APPEAL ON MSAPPL1.APCLNT.COSSN = MSAPPL1.APPEAL.COSSN
INNER JOIN MSAPPL1.T2CLM ON MSAPPL1.APCLNT.COSSN = MSAPPL1.T2CLM.COSSN
INNER JOIN MSAPPL1.JURIS ON MSAPPL1.APCLNT.COSSN = MSAPPL1.JURIS.COSSN
INNER JOIN MSAPPL1.APPLCHAR ON MSAPPL1.APCLNT.COSSN = MSAPPL1.APPLCHAR.COSSN
INNER JOIN MSAPPL1.APLDETN ON MSAPPL1.APCLNT.COSSN = MSAPPL1.APLDETN.COSSN
INNER JOIN MSAPPL1.UNIT ON MSAPPL1.APCLNT.COSSN = MSAPPL1.UNIT.COSSN

Hearty head pats

LM_Release2
Starting Member

4 Posts

Posted - 2006-04-18 : 11:24:42

THANKS ALOT!!!! IT WORKS!!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources