/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 vote180 views1 answer
Ms sql print more than 1 variable
SQL
0 vote273 views1 answer
The differnece between to values in sql
SQL
1 vote140 views1 answer
Oracle sql create or replace view
SQL
0 vote135 views1 answer
Data structures in sql
SQL
1 vote186 views1 answer
Sqlite show columns in table
SQL
1 vote142 views1 answer
Sample in sql
SQL
0 vote137 views1 answer
Java sql timestamp now
SQL
0 vote152 views1 answer
Unique element in sql
SQL
1 vote188 views4 answers
Alter schema sql
SQL
0 vote178 views1 answer
Opensuse start MySQL
SQL