/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

0 vote212 views1 answer
Mod function example
SQL
0 vote248 views1 answer
SQL joins in python
SQL
0 vote231 views1 answer
Mysql grouping functions
SQL
1 vote239 views1 answer
Mysql drop key
SQL
0 vote248 views1 answer
Replace divide by zero error with 0 in sql
SQL
4 votes225 views1 answer
Force drop all tables postgres
SQL
9 votes257 views3 answers
Pyodbc connect to sql server
SQL
0 vote284 views1 answer
Mysl like insert a variable
SQL
1 vote228 views1 answer
SQL date part only of datetime
SQL
3 votes270 views1 answer
Mysql group_concat distinct
SQL