/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

8 votes238 views1 answer
Insert a select statement into a table
SQL
4 votes182 views2 answers
REST API
SQL
0 vote170 views1 answer
Insert data from stored procedure into table
SQL
1 vote121 views1 answer
Mysql collation
SQL
0 vote170 views2 answers
Check mysql timezone
SQL
0 vote177 views1 answer
Tsql pad left
SQL
1 vote219 views1 answer
Add time to date sql
SQL
0 vote158 views1 answer
Mysql money value
SQL
0 vote185 views1 answer
Renommer base sql
SQL
0 vote170 views1 answer
Primary key multiple colums
SQL