/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 vote156 views1 answer
Nosql vs sql
SQL
0 vote136 views1 answer
Clone table structure mysql
SQL
1 vote172 views1 answer
Mysql previous year
SQL
0 vote161 views1 answer
Sql statement show all emails with dome
SQL
0 vote186 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote169 views1 answer
Command to give readonly access to a postgres sql user
SQL
5 votes158 views4 answers
Upload database mysql command line
SQL
0 vote156 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
3 votes140 views1 answer
APEX elapsed time
SQL
0 vote162 views1 answer
Delete ids between sql
SQL