- 1

Custom Names

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;

12th Aug 2021, 6:43 AM
ARISTIDE ON-KEBA YAGO DERING
ARISTIDE ON-KEBA YAGO DERING - avatar
3 odpowiedzi
+ 2
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?
12th Aug 2021, 8:26 AM
Ipang
+ 1
Il manque quelque chose avant le .name FROM Pour les autres blancs j'ai déjà rempli, merci !
12th Aug 2021, 7:51 AM
ARISTIDE ON-KEBA YAGO DERING
ARISTIDE ON-KEBA YAGO DERING - avatar
0
What??
12th Aug 2021, 7:09 AM
Parth
Parth - avatar