Question 13, self-test after 3 Lesson

For students who study 1C:Professional course.

Pages: 1

Nadiia Liubiva	#1 People who like this: 0 Yes / 0 No Jul 21, 2015 11:16 AM
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? 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?

Konstantin Rupasov	#2 People who like this: 0 Yes / 0 No Jul 21, 2015 01:19 PM
Moderator 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

Pages: 1

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