/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 vote277 views1 answer
How to check oracle index table
SQL
0 vote325 views1 answer
Enable full text search mysql
SQL
0 vote327 views1 answer
Formatting code with SQL Developer
SQL
0 vote330 views3 answers
Postgresql grant alter table to user
SQL
1 vote327 views2 answers
Mysql filter by date mount
SQL
-1 vote316 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote333 views1 answer
Less mysql display
SQL
0 vote350 views1 answer
Mysql remove bad character from all fields
SQL
0 vote295 views1 answer
Sql random decimal
SQL
0 vote307 views1 answer
Deny select insert update delete sql
SQL