/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 vote210 views1 answer
Table valued functions in sql
SQL
2 votes213 views1 answer
Sql server check for value in multiple columns
SQL
17 votes199 views3 answers
Cast in sql server
SQL
0 vote152 views1 answer
Update sql join multiple tables
SQL
0 vote198 views1 answer
Psql initialization
SQL
11 votes223 views5 answers
Sql server reset identity
SQL
0 vote286 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
3 votes255 views1 answer
Sql select second max
SQL
4 votes274 views1 answer
Postgresql list sequences
SQL
5 votes242 views2 answers
Functions
SQL