/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 vote126 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote131 views1 answer
Sqlite get date only
SQL
0 vote123 views1 answer
Copy Table from SQL to CSV
SQL
0 vote182 views1 answer
Replace null value within column mysql
SQL
1 vote169 views1 answer
Add time to date sql
SQL
0 vote140 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote145 views1 answer
Mysql export data with a where clause
SQL
6 votes137 views3 answers
Date_trunc postgres
SQL
0 vote139 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
4 votes154 views1 answer
Mysql delete last row
SQL