/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 vote298 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote310 views1 answer
Postgresql import a database of gzip
SQL
0 vote336 views1 answer
ORA-13717
SQL
1 vote298 views1 answer
Select statement to print longest name
SQL
0 vote304 views4 answers
How to drop all tables in sql
SQL
3 votes344 views2 answers
How to force truncate a table in mysql
SQL
-1 vote308 views1 answer
Mysql #1064 error
SQL
0 vote322 views1 answer
How to update sql server version
SQL
0 vote364 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote269 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL