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?

Answer 1

OUTER

ON

Answer 2

Total 4 columns will be displayed in the result. Name, id from customers and name, seller_id from items.