/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

33 votes109 views6 answers
Sql delete
SQL
16 votes117 views2 answers
Sql vs nosql
SQL
1 vote98 views1 answer
Mysql connect bash
SQL
0 vote124 views1 answer
Check constraint is violated
SQL
0 vote79 views1 answer
Separator mysql
SQL
0 vote100 views2 answers
Oracle create chain rule
SQL
0 vote104 views1 answer
Mysql_union
SQL
6 votes93 views4 answers
Mysql update set
SQL
0 vote100 views1 answer
Datetime postgres typeorm
SQL
0 vote110 views1 answer
Wordpress sql find and replace
SQL