/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 vote152 views1 answer
Oracle swap partition
SQL
0 vote142 views1 answer
C# check if mysql query modified rows
SQL
17 votes157 views5 answers
Order by sql
SQL
8 votes143 views6 answers
Sql insert
SQL
0 vote129 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote146 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote153 views1 answer
Sqlite get date only
SQL
1 vote189 views1 answer
How to select random rows from a table
SQL
3 votes171 views1 answer
Apex set debug level
SQL
0 vote159 views1 answer
Postgresql inline table
SQL