SQL Join (Nickname)

Really stuck on this one: Fill 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_ct, items AS it WHERE it.seller_id=_.id;

20th Mar 2018, 7:52 PM
Duncan Allers
2 ответов
+ 1
SELECT ct.name, it.name FROM customers_ct, items AS it WHERE it.seller_id=ct.id; I assume those other lines represents whitespaces
20th Mar 2018, 7:56 PM
Toni Isotalo
Toni Isotalo - avatar
# it, AS, ct ```sql SELECT ct.name, it.name FROM customers_ct AS ct, items AS it WHERE it.seller_id = ct.id; ```
20th Aug 2020, 3:42 PM
xgqfrms - avatar