Desktop version

Main > Forum > Learning > 1C:Professional questions > Question 13, self-test after 3 Lesson

Forum

Search UsersRules
Question 13, self-test after 3 Lesson
#1
Just came
Points:: 0
Joined:: May 15, 2015

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?

Profile
#2
Moderator
Points:: 0
Joined:: May 8, 2013

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

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



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.