Question : I have a basic problem about create a query for listing artists with a condition of the artist […]
Category: Join
Many-to-Too-Many Relationship
Question : I’m working on a book database. And among others, I have the following two tables (a bit simplified […]
How to increase the value of a column in a table by a constant by consulting another table?
Question : I have prepared the database of the college given as create table depts( deptcode char(3) primary key, deptname […]
How to apply outer limit offset and filters in the subquery to avoid grouping over the complete table used in subquery in Postgresql
Question : I have legacy tables similar to the following: employee ———————————— | employee_id | name ———————————— | 1 | […]
Select Sum from two joined tables
Question : There are structures: CREATE TABLE `invoices` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `date` date NOT NULL, PRIMARY […]
Simple left outer join leaving me with inner join
Question : So I have a table with each record being a change to an object. e.g. in the app […]
Full outer join problems
Question : I’m trying to create an xml with customer specific prices for a webshop I am working on atm. […]
Joining two tables on multiple criteria
Question : I have two tables products and positions. products: id BIGINT PRIMARY KEY, product VARCHAR(100), criterium1 VARCHAR(100), criterium2 VARCHAR(100) […]
SQL Update column with another table column
Question : I’m using Postgres 9.4, and already seen others asking the same (simple) question, but theirs answers do not […]
how to select query to inner join same column twice?
Question : Table A: Col1 [TicketSubject] Col2 [Createuserid] Col3 [Modifyuserid] Table B: Col1 [ID] Col2 [Name] How I imagine it […]