/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 vote236 views1 answer
Sql recherche nom prenom
SQL
6 votes236 views1 answer
Identify primary key in oracle table
SQL
4 votes238 views2 answers
Show all database inside postgresql
SQL
0 vote234 views1 answer
T sql check active deadlock
SQL
1 vote251 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote234 views1 answer
View psql output in horizontal scrolling
SQL
2 votes241 views1 answer
How to find table table in stored procedure sql server
SQL
10 votes228 views1 answer
Dba_dependencies
SQL
0 vote232 views2 answers
Sql regex vowel
SQL
0 vote264 views1 answer
Create table like sql
SQL