/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

6 votes322 views5 answers
Oracle list tablespaces
SQL
8 votes284 views2 answers
Python simple connect to mysql
SQL
0 vote280 views1 answer
How to fetch unique records from two tables
SQL
9 votes256 views2 answers
Default number in sql
SQL
0 vote280 views1 answer
How to select only id where is not in column mysql
SQL
4 votes269 views1 answer
Oracle user tables
SQL
0 vote262 views1 answer
Mysql update sequence with order by
SQL
58 votes480 views4 answers
Mysql drop column
SQL
0 vote288 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
1 vote267 views1 answer
Median mysql
SQL