Join Query

babydeveloper · #1 (**permalink**) 12-09-09, 09:20

Hi,

I am new to mysql. I Have made a small data base and i need some help for joins.

There are three tables
1. user
user_id (pk)
user_name
user_address

2. contact
contact_id(pk)
contact_name

3. user_contact
user_id(pk)
contat_id(pk)

Now u can see there exists many to many relationship between user and contact table that is one user can have many contacts and one contact can be in the contact list of many users; so for normalization i made a junction table with name user_contact

The problem is i want to fetch username and its all contacts from contact table but i do not how to join these three tables to get data from user table and contact table. Can any write the join query that can solve the problem.

r937 · #2 (**permalink**) 12-09-09, 10:07

Code:

SELECT u.user_id
     , u.user_name
     , u.user_address
     , c.contact_id
     , c.contact_name
  FROM user AS u
INNER
  JOIN user_contact AS uc
    ON uc.user_id = u.user_id
INNER
  JOIN contact AS c
    ON c.contact_id = uc.contact_id

babydeveloper · #3 (**permalink**) 12-09-09, 23:50

Thanks a lot. It really worked for me....Nice.....

Internet Services

Web Development

Digital Marketing

Consumer Tech