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.
| Author |
Topic |
|
sqlchiq
Posting Yak Master
133 Posts |
 Posted - 2010-07-13 : 16:52:17
|
| select a.date, a.home, a.away, a.time, b.overall HomeOverall, b.offense HomeOffense,b.defense HomeDefense,x.num HomeOverallN, y.num as HomeOffenseN,z.num HomeDefenseNfrom teamranks b, gameslist a LEFT OUTER JOIN dbo.ncaagrades AS x ON b.overall = x.grade LEFT OUTER JOIN dbo.ncaagrades AS y ON b.offense = y.grade LEFT OUTER JOIN dbo.ncaagrades AS z ON b.defense = z.gradeI'm getting that multipart identifier b.overall, b.offense, and b.defense from the last section involving the joins could not be bound.not sure how to approach this |
|
|
karepa
Starting Member
3 Posts |
Posted - 2010-07-13 : 21:33:28
|
| Hi.You are not linking gamelist a.Unless you are doing it at where clauseCheers,Karepa |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-14 : 02:21:29
|
| You have Cartesian join between teamranks and gameslist but you want to JOIN the other tables to teamranks - in which case you need to move the JOINs to be on the teamranks side of the Cartesian join... from gameslist a, teamranks b LEFT OUTER JOINdbo.ncaagrades ...I presume you did intend to have a Cartesian join? |
|
|
|
|
|
|
|
|
Joining 3 tables, multipart identifier not bound