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 |
|
dainova
Starting Member
31 Posts |
 Posted - 2010-04-08 : 18:35:49
|
| Hi, anybody can help me how get this join.I have to join c.artist_rate to a.* selection having this 2 step relationship1. b.artist_id = a.artist2. c.artist_rate where c.artist_no = b.artist_id There is no direct relationship between main <a> and <c> tables.select a.*, c.artist_ratefrom diskinfo a join catalog b on a.artist = b.artist_id and (?) join rating c on b.artist_id = c.artist_noIt doens't work for me now, will appreciate youre response.v |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-08 : 18:52:57
|
| Any chance of sample data?There are 10 types of people in the world, those that understand binary, and those that don't. |
 |
|
|
|
|
|
multiple join