/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 vote280 views1 answer
Oracle sql add column auto generated value
SQL
0 vote267 views1 answer
Sqlite to csv statement
SQL
0 vote290 views1 answer
Mysql dump with table query
SQL
2 votes257 views1 answer
Oracle cpu per session
SQL
5 votes270 views1 answer
Ora-00054 find lock
SQL
0 vote270 views1 answer
Sql bild in function
SQL
18 votes257 views6 answers
Drop table if exists
SQL
0 vote279 views1 answer
Excel export from sql using python
SQL
3 votes301 views5 answers
No module named 'MySQLdb'
SQL
3 votes283 views2 answers
Sqlite show table structure
SQL