/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

9 votes344 views2 answers
Current date in postgresql minus 1 day
SQL
3 votes212 views1 answer
DB: in eloquent using sql
SQL
0 vote280 views1 answer
How to login to mysql in homestead
SQL
0 vote183 views1 answer
Postgresql get current user name
SQL
3 votes251 views2 answers
Brew restart mysql
SQL
0 vote215 views1 answer
Mysql delete from where like
SQL
0 vote158 views1 answer
Online sql compiler
SQL
48 votes294 views3 answers
Psql create database
SQL
65 votes556 views6 answers
Sql add column to table
SQL
0 vote221 views1 answer
Copy column from one table to another without column duplicate postgres
SQL