select int, out from income_o full join outcome_o

Why is an error trail.

Ошибка. Incorrect syntax near ';'.

  • missing 'on'. Alphabet truths need to comprehend in another place). Well, if this is just inattention (which happens to everyone), then the question is not interesting, does not carry any information - ale

3 answers 3

A table with Incas should be combined with a table with a set of some field, for example:

 SELECT int, out FROM income_o FULL JOIN outcome_o ON outcome_o.inc_id = income_o.id

Or, if you just need to select all the values, then the join is not needed, just the table names are indicated:

 SELECT int, out FROM income_o, outcome_o

    You did not indicate where and by what field you are going to join.

    • It seems to have indicated that the Ink table is a complete external integration with the table in more detail, plz and it does not reach) - vegas
    • there is no connection condition (ON instruction) - for example, specifying the connection fields of the tables being linked - ale

    If you need a Cartesian connection, use CROSS JOIN, not FULL. FULL means that you are connecting by a specific field (i.e. an ON operator is required ...), and means that you need to return values ​​from both the left and right tables, even if they did not find the corresponding values.