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 |
|
Elango
Starting Member
1 Post |
 Posted - 2012-03-31 : 03:07:24
|
| Hi, I'm getting duplicate data, while joining 3 tables. the query is given below. Please help.select tbl_user.Refid,tbl_user.name,tbl_user.photoid,tbl_status.msg,tbl_status.date from tbl_user inner join tbl_status on tbl_user.Refid=tbl_status.refid full join tbl_friend on tbl_user.RefId=tbl_status.Refid where tbl_friend.frnds=1 and tbl_friend.toRefId=1 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-03-31 : 03:28:12
|
Why FULL JOIN?Replace with INNER JOIN.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-31 : 19:30:09
|
| post some data from tables and elaborate on what according to you are "duplicates". Also give expected output.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Duplicate data while joining 3 tables