/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

15 votes219 views4 answers
Sql update from select
SQL
0 vote248 views2 answers
Impala rename column name
SQL
61 votes330 views6 answers
Mysql add column
SQL
0 vote211 views1 answer
Oracle step procedure
SQL
2 votes222 views1 answer
Sql percentage with % rounded down
SQL
0 vote213 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
8 votes204 views1 answer
Oracle add month
SQL
1 vote215 views1 answer
Oracle datafile max size 32gb
SQL
0 vote202 views1 answer
How to access to mysql without root
SQL
0 vote213 views1 answer
Mysql could not fetch tables
SQL