Custom Names

Question

Film in the blanks to select item names and names of customers who bought the items. Use custom names to shorten the statement.

SELECT ct.name, .name

FROM customers AS ct, items AS it

WHERE it.seller_id=ct.id;

Answer 1

SELECT ct.name, it.name
FROM customers AS ct, items AS it
WHERE ...

I don't see any instruction to filter by ct.id or it.seller_id. Are you sure about the WHERE clause?.

I also think the condition in WHERE clause could possibly be wrong. How can a customer (identified by ct.id) be the seller (identified by it.seller_id) at the same time?

Answer 2

Il manque quelque chose avant le .name FROM
Pour les autres blancs j'ai déjà rempli, merci !

Answer 3

What??