/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 vote186 views3 answers
How to get date in sql
SQL
0 vote197 views1 answer
Alter table change default
SQL
2 votes327 views1 answer
How to create sql database
SQL
0 vote640 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote205 views1 answer
Check if a column is a primary key in sql server
SQL
1 vote204 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote177 views1 answer
Join creating duplicate columns sqllite
SQL
3 votes270 views1 answer
How to get yesterday date in sql
SQL
0 vote184 views1 answer
C# check if mysql query modified rows
SQL
0 vote202 views1 answer
Oracle last connexion
SQL