How To Combine Data From Multiple Tables Using SQL?

I have following tables in my MySql database : +----------------------------------------------+ PROJECT +----------------------------------------------| +----

Solution 1:

This should do the trick... a group by and a group_concat

select 
    pr.project_id, 
    pr.team_size, 
    pr.from_date, 
    GROUP_CONCAT(tech.technology_name separator ', ') as technologies
from  
    project pr 
    JOIN project_technologies ptech ON pr.project_id=ptech.project_id
    JOIN technologies tl ON ptech.technology_id=tl.technology_id
GROUP BY
    pr.project_id, 
    pr.team_size, 
    pr.from_date

EDIT fixed to include JOIN clause

Solution 2:

Try this one -

SELECT p.*, GROUP_CONCAT(t.technology_name) technologies FROM project p
  JOIN project_technologies pt
    ON pt.project_id = p.project_id
  JOIN technologies t
    ON t.technology_id = pt.technology_id
GROUP BY p.project_id;

Solution 3:

USE THIS:

SELECT PROJECT.*, Technologies.* FROM Project_Technologies
INNER JOIN PROJECT ON Project_Technologies.Project_ID = PROJECT.project_id
INNER JOIN Technologies ON Project_Technologies.Technology_ID = Technologies.technology_id