What if I want to execute "SELECT customers.Name, customers.ID, items.Name, items.Seller_id FROM customers LEFT OUTER JOIN items ON customers.ID=items.Seller_id;" Will there be two more column displayed with the customer id and seller id? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

What if I want to execute "SELECT customers.Name, customers.ID, items.Name, items.Seller_id FROM customers LEFT OUTER JOIN items ON customers.ID=items.Seller_id;" Will there be two more column displayed with the customer id and seller id?

21st Apr 2016, 5:38 AM
Trishal Agarwal
Trishal Agarwal - avatar
2 Answers
+ 1
OUTER ON
9th Jul 2021, 1:30 PM
Abad Abdilah
Abad Abdilah - avatar
- 1
Total 4 columns will be displayed in the result. Name, id from customers and name, seller_id from items.
20th Jun 2016, 7:53 PM
Siva Madhusudhan Reddy