/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 vote276 views2 answers
Mysql multiply
SQL
6 votes266 views1 answer
Oracle trigger after connect
SQL
0 vote283 views1 answer
How to connect postgresql database with java
SQL
2 votes282 views1 answer
Wait delay in sql server
SQL
0 vote314 views1 answer
Hashpass
SQL
5 votes316 views1 answer
Mysql add user with all privileges
SQL
47 votes349 views6 answers
Add column mysql
SQL
0 vote268 views1 answer
Database springboot
SQL
14 votes297 views1 answer
Oracle new column
SQL
0 vote283 views1 answer
Liquibase update row
SQL