Question 13, self-test after 3 Lesson



For students who study 1C:Professional course.

#1
People who like this:0Yes/0No
Just came
1C:Professional
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?

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?

 
#2
People who like this:0Yes/0No
Moderator
1C:Professional
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!

 
Subscribe