/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

34 votes121 views6 answers
Sql change data type
SQL
0 vote160 views1 answer
Day of the week sqlite
SQL
3 votes121 views1 answer
APEX elapsed time
SQL
0 vote139 views1 answer
Mysql coonect sample code
SQL
0 vote128 views1 answer
How to output a different column name in mysql
SQL
0 vote125 views1 answer
Mysql cdn link
SQL
7 votes122 views6 answers
Reset identity column in sql server
SQL
0 vote144 views2 answers
How to install mssql on mac
SQL
0 vote130 views1 answer
Watch mysql command line
SQL
0 vote131 views1 answer
Oracle synonym procedure
SQL