/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 vote157 views1 answer
Set mysql socket file docker windows
SQL
0 vote192 views1 answer
Sql to excel pgadmin
SQL
1 vote154 views1 answer
Mysql size int
SQL
1 vote158 views1 answer
How to unlock table in mysql
SQL
0 vote152 views1 answer
Codeigniter dbforge add index
SQL
0 vote158 views1 answer
Exectuer myssql .sql
SQL
1 vote141 views1 answer
Declare table variable
SQL
1 vote174 views1 answer
How to put value in variable mysql
SQL
0 vote142 views1 answer
First mysql
SQL
0 vote153 views1 answer
Mysql date only no time
SQL