All geek questions in one place

Is the order of natural associations consistent?

If I say:

A NATURALJOIN B

This is the same as:

B NATURALJOIN A

Similarly, if I say:

A NATURALJOIN B NATURALJOIN C

How should this be evaluated?

+4
source share
1 answer

Here are my comments:

  • NATURALJOIN are two words: NATURAL JOIN
  • The order of the tables does not matter. Exception: when you are SELECT *, then the list of selected columns is all the columns of the first table, and then all the columns of the second table.
  • NATURAL JOIN s. . , "", "" "", . , SELECT, person_id. "" . - , "person_id" , "" .
+8

Source: https://habr.com/ru/post/1533103/

More articles:


All Articles