/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

3 votes206 views1 answer
Null sql
SQL
0 vote183 views1 answer
Online sql compiler
SQL
0 vote243 views1 answer
Combine 2 columns search query mysql
SQL
2 votes277 views3 answers
Mysql cheat sheet
SQL
19 votes247 views5 answers
Display table in sql
SQL
2 votes191 views1 answer
Scaffold npgsql net core
SQL
0 vote202 views2 answers
Alter table add multiple columns mysql
SQL
0 vote224 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
5 votes202 views3 answers
Sql make column nullable
SQL
0 vote193 views1 answer
Get number of table colums in sql query
SQL