Error in the topic-wise question for Left Join

Question

In the type of joins module, there is an error in the question after the "Left-join" topic(given below). Please rectify it

Drag and drop from the options below to outer join the table ''items'' with ''customers''.

SELECT customers.name, items.name
FROM customers
LEFT JOIN items
customers.id=seller_id.......................table 2 name missing

Answer 1

Jimmy the invincible That is Ok. There is nothing wrong. Actually we write the secondry table after the JOIN command. And in that example already mentioned second table after JOIN. If you will try to write after that condition where you are saying, your query will give error.

See another example here.

https://www.google.com/amp/s/www.geeksforgeeks.org/sql-join-set-1-inner-left-right-and-full-joins/amp/