JOIN NOW

Informatics Practices

Below are the customer and order tables :

Customers

customer id (PK)
first_name
last_name
email
address
city
state
zip

Orders

order id (PK)
order_date
amount
customer_id (FK)

List all customers (name) who have orders (use EXISTS).

SQL Queries

2 Likes

Answer

SELECT first_name, last_name
FROM Customers c
WHERE EXISTS (
    SELECT first_name, last_name
    FROM Orders o
    WHERE o.customer_id = c.customer_id
);

Answered By

1 Like

Related Questions