/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

16 votes115 views3 answers
Jwt secret key generator laravel
SQL
1 vote110 views2 answers
Change table name phpmyadmin
SQL
3 votes111 views3 answers
Stop mysql service ubuntu
SQL
0 vote120 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote114 views1 answer
Psql list view rules
SQL
0 vote142 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote107 views1 answer
Turnicate in mysql
SQL
0 vote111 views1 answer
Search mysql database for column
SQL
0 vote124 views1 answer
Add mysql database to power bi web
SQL
0 vote103 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL