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: 6
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
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.