0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

CREATE TABLE #customers(
customer_id INT,
name VARCHAR(100));

CREATE TABLE #orders(
order_id INT,
quantity INT,
order_date DATETIME, customer_id INT);

INSERT INTO #customers(customer_id, name) VALUES (1, 'COMPANY_A')

INSERT INTO #customers(customer_id, name) VALUES (2, 'COMPANY_B')

INSERT INTO #orders(order_id, quantity, order_date, customer_id) VALUES (1, 5, '2019-01-01', 1)

INSERT INTO #orders(order_id, quantity, order_date, customer_id) VALUES (2, -2, '2019-01-05', 1)

SELECT c.name, o.order_date
    FROM #customers c
    INNER JOIN #orders o
    ON c.customer_id = o.customer_id
    WHERE o.order_date = 
    (SELECT max(order_date) FROM #orders where order_id = o.order_id)

view current version

edited feb 28 19

created feb 28 19 anonymous