/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 vote321 views1 answer
Sql auto_increment syntax
SQL
0 vote348 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
1 vote326 views2 answers
Mysql current user
SQL
0 vote340 views1 answer
Db format in quotation
SQL
1 vote322 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote351 views1 answer
Flask sqlalchemy session delete
SQL
1 vote321 views2 answers
Mysql does sentance contain word
SQL
0 vote365 views1 answer
Openquery update linked server
SQL
0 vote326 views1 answer
Oracle sql winter time change
SQL
3 votes339 views2 answers
Brew restart mysql
SQL