/SQL/Mysql join same table multiple times group by

Mysql join same table multiple times group by

SELECT 
    ticket.ticket_id,  
    a1.attr_val AS attr_val1,
    a2.attr_val AS attr_val2,
    a3.attr_val AS attr_val3
FROM ticket
    LEFT JOIN attr a1 ON ticket.ticket_id=a1.ticket_id AND a1.attr_type=1
    LEFT JOIN attr a2 ON ticket.ticket_id=a2.ticket_id AND a2.attr_type=2
    LEFT JOIN attr a3 ON ticket.ticket_id=a3.ticket_id AND a3.attr_type=3

Source: stackoverflow.com

Similar codes

2 votes422 views1 answer
Capitalize 1st letter in sql server
SQL
7 votes389 views5 answers
Max 3 salary in sql
SQL
3 votes373 views2 answers
Postgresql remove not null constraint
SQL
0 vote373 views1 answer
Declarative base sqlalchemy
SQL
0 vote360 views1 answer
Call rest api from postgresql
SQL
0 vote368 views1 answer
Sql alter table order by
SQL
0 vote350 views1 answer
Sql server update top n records
SQL
1 vote383 views1 answer
Mysql previous year
SQL
25 votes362 views6 answers
Change column name mysql
SQL
0 vote359 views1 answer
Show table details postgresql
SQL