Question 13, self-test after 3 Lesson

For students who study 1C:Professional course.

People who like this:0Yes/0No
Just came
Rating: 0
Joined: May 15, 2015
Company: CloudOffice AB

here is a Catalog1 with three records in it. What will be the result of the following query execution?

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?

People who like this:0Yes/0No
Rating: 4
Joined: May 8, 2013
Company: 1C Company

Yes, you are absolutely right. There was an error in the query text. Now it's fixed. Thank you very much!

Users browsing this topic (guests: 0, registered: 1, hidden: 0)