/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 vote357 views1 answer
Mysql enter ubuntu
SQL
0 vote349 views1 answer
Postgresql select fast check no rows
SQL
0 vote352 views1 answer
Mysql bind-address default value
SQL
8 votes350 views1 answer
Oracle tablespace datafile max size
SQL
6 votes341 views1 answer
To count number of rows in SQL table
SQL
1 vote339 views1 answer
Set statiscis on in sql server
SQL
0 vote391 views1 answer
Psql check if sql script is valid
SQL
0 vote348 views1 answer
Sql drop default
SQL
0 vote386 views1 answer
Query builder doctrien return sql
SQL
5 votes364 views2 answers
Oracle apex debug mode
SQL