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 |
|
eem_2055
Yak Posting Veteran
69 Posts |
 Posted - 2008-05-18 : 06:49:33
|
| Hi guys can you help me joining three tables?I used to join all those three but there's a redundant on it's value..Table1 ID Account 1 A 2 B 3 C Table 2 ID Name 1 A 2 B 3 C Table 3 Account Name 456 ABC 456 ABC 456 ABC with the following result:(what query should I use?)ID Name AcctName Account ID2 Name2 ID3 Name31 A ABC 456 2 B 3 C |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-18 : 21:08:15
|
| How can you join third table? No common column in it. |
 |
|
|
|
|
|
Joining Tables