/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 vote181 views1 answer
T-sql disable system versioning
SQL
0 vote171 views1 answer
Google cloud sql postgres url example
SQL
0 vote146 views1 answer
Power query case when
SQL
5 votes163 views1 answer
Sort order on two columns sql
SQL
2 votes169 views1 answer
Node and mysql like
SQL
22 votes151 views3 answers
Join three tables sql
SQL
4 votes149 views1 answer
Mysql copy table with new name
SQL
1 vote100 views1 answer
Insert into sql
SQL
0 vote166 views1 answer
Enable sql server full text indexing
SQL
1 vote166 views1 answer
Sql select whole row max column
SQL