JOINS Question.
How can we determine what join based on a query
ex) SELECT * FROM ORDERS
JOIN
ON ORDERS.CUSTOMER ID=
CUSTOMERS.CUSTOMER ID;
How can we determine what join is described based on this information?
1 answers ( 0 marked as helpful)
Hi Shaterra!
Thanks for reaching out!
By default, if the type of JOIN is not specified, it is implicitly understood to be an INNER JOIN. This means that only those records with matching values in both tables are selected.
Regarding your query, please don't forget to specify the table you'll be joining as well (right after the JOIN clause.
Hope this helps.
Best,
Ivan
Submit an answer
