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
 General SQL Server Forums
 New to SQL Server Programming
 How to remove duplicate on sql server using framer

Author  Topic 

shehuzaaa
Starting Member

2 Posts
Posted - 2014-06-05 : 11:28:29
Good day guys please how can i solve this problem when ever i try to join multiple Tables it will appear in duplicate.Thanks i will look forward for your reply.
eaxmple:

ID SURNAME NAME SEX DOB

1 YAHAY ISA MALE 05.02.1991 1 NIGERIA KADUNA 12 RIMI ROAD
1 YAHAY ISA MALE 05.02.1991 2 USA LONDON 12 NEW JESSY
1 YAHAY ISA MALE 05.02.1991 3 BENIN TOGO 12 KIMOI ROAD
1 YAHAY ISA MALE 05.02.1991 4 KENYA YANE 8 MUTU AVENUE
1 YAHAY ISA MALE 05.02.1991 5 BRAZIL LAZZIO 4 ZINO AVENUE
2 IBRAHIM JAMILA FEMALE 04.05.2001 1 NIGERIA KADUNA 12 RIMI ROAD
2 IBRAHIM JAMILA FEMALE 04.05.2001 2 USA LONDON 12 NEW JESSY
2 IBRAHIM JAMILA FEMALE 04.05.2001 3 BENIN TOGO 12 KIMOI ROAD
2 IBRAHIM JAMILA FEMALE 04.05.2001 4 KENYA YANE 8 MUTU AVENUE
2 IBRAHIM JAMILA FEMALE 04.05.2001 5 BRAZIL LAZZIO 4 ZINO AVENUE
3 UMAR HADIZA FEMALE 04.04.2002 1 NIGERIA KADUNA 12 RIMI ROAD
3 UMAR HADIZA FEMALE 04.04.2002 2 USA LONDON 12 NEW JESSY
3 UMAR HADIZA FEMALE 04.04.2002 3 BENIN TOGO 12 KIMOI ROAD
3 UMAR HADIZA FEMALE 04.04.2002 4 KENYA YANE 8 MUTU AVENUE
3 UMAR HADIZA FEMALE 04.04.2002 5 BRAZIL LAZZIO 4 ZINO AVENUE
4 HARUNA IBRAHIM MALE 01.01.1980 1 NIGERIA KADUNA 12 RIMI ROAD
4 HARUNA IBRAHIM MALE 01.01.1980 2 USA LONDON 12 NEW JESSY
4 HARUNA IBRAHIM MALE 01.01.1980 3 BENIN TOGO 12 KIMOI ROAD
4 HARUNA IBRAHIM MALE 01.01.1980 4 KENYA YANE 8 MUTU AVENUE
4 HARUNA IBRAHIM MALE 01.01.1980 5 BRAZIL LAZZIO 4 ZINO AVENUE
5 KABIRU ISAMILA MALE 03.12.1982 1 NIGERIA KADUNA 12 RIMI ROAD
5 KABIRU ISAMILA MALE 03.12.1982 2 USA LONDON 12 NEW JESSY
5 KABIRU ISAMILA MALE 03.12.1982 3 BENIN TOGO 12 KIMOI ROAD
5 KABIRU ISAMILA MALE 03.12.1982 4 KENYA YANE 8 MUTU AVENUE
5 KABIRU ISAMILA MALE 03.12.1982 5 BRAZIL LAZZIO 4 ZINO AVENUE

James K
Master Smack Fu Yak Hacker

3873 Posts
Posted - 2014-06-05 : 11:57:16
quote:
Originally posted by shehuzaaa

Good day guys please how can i solve this problem when ever i try to join multiple Tables it will appear in duplicate.Thanks i will look forward for your reply.
eaxmple:

ID SURNAME NAME SEX DOB

1 YAHAY ISA MALE 05.02.1991 1 NIGERIA KADUNA 12 RIMI ROAD
1 YAHAY ISA MALE 05.02.1991 2 USA LONDON 12 NEW JESSY
1 YAHAY ISA MALE 05.02.1991 3 BENIN TOGO 12 KIMOI ROAD
1 YAHAY ISA MALE 05.02.1991 4 KENYA YANE 8 MUTU AVENUE
1 YAHAY ISA MALE 05.02.1991 5 BRAZIL LAZZIO 4 ZINO AVENUE
2 IBRAHIM JAMILA FEMALE 04.05.2001 1 NIGERIA KADUNA 12 RIMI ROAD
2 IBRAHIM JAMILA FEMALE 04.05.2001 2 USA LONDON 12 NEW JESSY
2 IBRAHIM JAMILA FEMALE 04.05.2001 3 BENIN TOGO 12 KIMOI ROAD
2 IBRAHIM JAMILA FEMALE 04.05.2001 4 KENYA YANE 8 MUTU AVENUE
2 IBRAHIM JAMILA FEMALE 04.05.2001 5 BRAZIL LAZZIO 4 ZINO AVENUE
3 UMAR HADIZA FEMALE 04.04.2002 1 NIGERIA KADUNA 12 RIMI ROAD
3 UMAR HADIZA FEMALE 04.04.2002 2 USA LONDON 12 NEW JESSY
3 UMAR HADIZA FEMALE 04.04.2002 3 BENIN TOGO 12 KIMOI ROAD
3 UMAR HADIZA FEMALE 04.04.2002 4 KENYA YANE 8 MUTU AVENUE
3 UMAR HADIZA FEMALE 04.04.2002 5 BRAZIL LAZZIO 4 ZINO AVENUE
4 HARUNA IBRAHIM MALE 01.01.1980 1 NIGERIA KADUNA 12 RIMI ROAD
4 HARUNA IBRAHIM MALE 01.01.1980 2 USA LONDON 12 NEW JESSY
4 HARUNA IBRAHIM MALE 01.01.1980 3 BENIN TOGO 12 KIMOI ROAD
4 HARUNA IBRAHIM MALE 01.01.1980 4 KENYA YANE 8 MUTU AVENUE
4 HARUNA IBRAHIM MALE 01.01.1980 5 BRAZIL LAZZIO 4 ZINO AVENUE
5 KABIRU ISAMILA MALE 03.12.1982 1 NIGERIA KADUNA 12 RIMI ROAD
5 KABIRU ISAMILA MALE 03.12.1982 2 USA LONDON 12 NEW JESSY
5 KABIRU ISAMILA MALE 03.12.1982 3 BENIN TOGO 12 KIMOI ROAD
5 KABIRU ISAMILA MALE 03.12.1982 4 KENYA YANE 8 MUTU AVENUE
5 KABIRU ISAMILA MALE 03.12.1982 5 BRAZIL LAZZIO 4 ZINO AVENUE

Usually that happens when you don't have sufficient conditions in your JOIN expression. In your example, it looks like the join between the "Users" table and the "Address" table is missing something - perhaps you are not joining on ID?

Can you post your query?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2014-06-06 : 08:38:18
Thats because the join condition between tables is not proper ie you've missed out one or more columns by which tables are related.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site