SQL Join (Nickname) | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

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 Answers
+ 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
0
# 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
xgqfrms - avatar