/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 vote218 views1 answer
PSQL qith variables
SQL
2 votes214 views1 answer
Install postgresql centos 5
SQL
0 vote210 views1 answer
How to add more columns to a table in mysql
SQL
0 vote206 views1 answer
Select even number id data from table
SQL
0 vote222 views1 answer
Oracle list datafiles
SQL
1 vote183 views1 answer
Floor function in sql oracle
SQL
2 votes226 views2 answers
Mysql show table column comments sql
SQL
0 vote218 views2 answers
Transaction php
SQL
0 vote201 views1 answer
Const pool = mysql.createpool()
SQL
0 vote198 views1 answer
How to install mysql without admin rights
SQL