Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: insert using condition postgres
Sql :: retrieve all data from a one row in mysql
Sql :: mysqli_free_result
Sql :: Unable to locate package libmysql-java
Sql :: postgres show table schema
Sql :: sql order
Sql :: datetrunc month sql
Sql :: prisma transaction
Sql :: Write an SQL query to fetch the count of employees working in the department ‘Admin’.
Sql :: sql not in operator
Sql :: oracle create index if not exists
Sql :: Write the order of execution of all the SQL clauses and statements
Sql :: greater than or equal to symbol in postgres
Sql :: insert into table using openquery
Sql :: oracle convert hours to minutes
Sql :: h2 auto increment and unique
Sql :: oracle sql get value from several rows and concatenate strings
Sql :: mysql create table
Sql :: mariadb cast null to 0
Sql :: show broken table mysql
Sql :: query only first letter string
Sql :: ubuntu install mysql 5.7
Sql :: how to create local postgres database
Sql :: mysql filter based on datediff
Sql :: cannot connect to mysql server 10060
Sql :: sql delete dastabase
Sql :: json object to column value in sql server
Sql :: what is common table expression in sql
Sql :: with transaction.atomic():
Sql :: select limit ms sql

Search

SQL

mysql join same table multiple times group by

ADD CONTENT