/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 vote309 views2 answers
Oracle create tablespace autoextend
SQL
0 vote297 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote305 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote277 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
1 vote297 views1 answer
Does insert into overwrite sql
SQL
3 votes275 views1 answer
Insert into table from another table mysql
SQL
0 vote333 views1 answer
Check command
SQL
9 votes290 views1 answer
Oracle get table schema
SQL
1 vote297 views1 answer
Mysql select if empty result
SQL
9 votes307 views4 answers
Oracle get table column names
SQL