here is a Catalog1 with three records in it. What will be the result of the following query execution?
Catalog1
Field1 Field2
1 1
2 2
3 3
SEL ECT C1_joined.Field1 FR OM Catalog.Catalog1 AS C1
LEFT JOIN Catalog.Catalog1 AS C1_joined
ON C1.Field1 = C1_joined.Field2 + 1
Right answer is "Three records with Field1 = NULL", but Field1 in the result table will not only NULL?
For students who study 1C:Professional course.