/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

1 vote86 views1 answer
Jooq convert using gbk
SQL
5 votes92 views3 answers
Oracle first day of last year
SQL
150 votes248 views10 answers
Grepper
SQL
0 vote108 views1 answer
Sql server insert inner join
SQL
0 vote93 views1 answer
Start and stop mysql
SQL
0 vote96 views1 answer
Top 3 salary in sql
SQL
0 vote117 views1 answer
Migrations.RunSQL
SQL
0 vote96 views1 answer
Can we rollback deleted data in sql
SQL
1 vote93 views3 answers
Union SQL
SQL
18 votes92 views6 answers
Creating table in MySQL
SQL