answer please | SoloLearn: Learn to code for FREE!

+2

answer please

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;

7/9/2017 5:40:09 PM

Tirth Luhar

8 Answers

New Answer

+2

SQL course would help you. select ct.name, it.name --> custom name for item's table from costumers AS ct, ----> assign custom name join items as it on it.seller = ct.id // the where clausule can help to filter the costumer or the item

+2

SELECT ct.name, .name FROM customers ct, items AS it WHERE it.seller_id= .id; ans it as ct

+1

+1

SELECT ct.name, it.name FROM customers as ct, items AS it WHERE it.seller_id=ct.id;

+1

+1

+1

Thanks

-1

SELECT ct.name, .name FROM customers ct, items AS it WHERE it.seller_id= .id; ans it as ct