/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 vote129 views1 answer
Find and replace database table phpmyadmin
SQL
4 votes138 views1 answer
Oracle error compilation line
SQL
0 vote139 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote170 views2 answers
Getting customers with no orders sql
SQL
0 vote104 views1 answer
Connection error in mysql workbench
SQL
0 vote146 views1 answer
Mysql workbench procedure
SQL
0 vote147 views1 answer
Convert int to varchar sql
SQL
1 vote172 views1 answer
Is sql fast
SQL
5 votes159 views1 answer
Oracle ora-00054 resource busy
SQL
11 votes198 views3 answers
Pl sql example
SQL