/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

2 votes308 views1 answer
Sql compare strings
SQL
0 vote241 views1 answer
Object Information
SQL
24 votes283 views4 answers
Postgres delete database
SQL
2 votes248 views1 answer
No data found oracle
SQL
0 vote250 views2 answers
How to start postgresql laravel
SQL
2 votes278 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote254 views1 answer
Oracle list of long running queries
SQL
18 votes247 views6 answers
Drop table if exists
SQL
2 votes251 views1 answer
Sql update alias
SQL
0 vote288 views10 answers
Sql statement checker corrector
SQL