/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 vote75 views1 answer
Sqlalchemy filter relationship
SQL
0 vote112 views1 answer
Oracle query archive mode
SQL
0 vote107 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote141 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
-1 vote128 views1 answer
Module operator in oracle sql
SQL
4 votes116 views3 answers
Mysql update with join
SQL
1 vote306 views1 answer
Foreign key in oracle sql developer
SQL
4 votes118 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote108 views1 answer
Oracle index hint multiple tables example
SQL
0 vote117 views1 answer
Get all employees if name ends with in sql
SQL