/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 vote305 views1 answer
Print intervals of 15 minutes in sql query
SQL
19 votes328 views6 answers
Mysql if null
SQL
2 votes312 views2 answers
Enable foreign key checks postgres
SQL
0 vote323 views1 answer
Alter boolean column postgresql
SQL
0 vote325 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote307 views1 answer
Create table sql generator
SQL
24 votes327 views5 answers
Import dump mysql
SQL
0 vote330 views1 answer
Modifier une valeur sql
SQL
0 vote298 views1 answer
Default value false mysql
SQL
0 vote317 views1 answer
Postgresql delete type
SQL