Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок0
Why is "items" not specified after the from statement after customers?
SELECT customers.name, items.name FROM customers (, items?) LEFT OUTER JOIN items ON customers.id=seller_id
1 ответ
0
it's a different mode for writing join statement between two table; the following instruction use a sequence of table name to put in join after FROM (the symbol + is associated to key of that table which values doesn't have correspondence)
SELECT customers.name, items.name
FROM customers , items
WHERE customers.id=items.seller_id(+)
this other statement instead use LEFT OUTER JOIN for the same result
SELECT customers.name, items.name
FROM customers
LEFT OUTER JOIN items ON customers.id=items.seller_id