/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 vote189 views1 answer
How to connect pgadmin with excel
SQL
-1 vote184 views1 answer
MYSQL stored procedure select from
SQL
1 vote221 views1 answer
Sql check roles
SQL
0 vote195 views1 answer
Mysql command line ubuntu
SQL
1 vote196 views1 answer
Moodle query item quiz
SQL
2 votes197 views1 answer
Ssh mysql port forwarding
SQL
5 votes191 views1 answer
AND OR NOT operators sql
SQL
23 votes181 views3 answers
Mysqldump
SQL
12 votes190 views1 answer
Psql drop column
SQL
17 votes212 views3 answers
Postgresql list users
SQL