Select from following answers:- Use the DEREF and KEY operator in the SELECT clause.
- Use the DEREF and NAVIGATE operators in the SELECT clause.

- Use the KEY and NAVIGATE operator in the SELECT clause.
- All Above
The correct syntax to navigate a relationship and retrieve a property from the associated entity is as follows:
SELECT p.FirstName, p.LastName, DEREF(NAVIGATE(p, TestLib.FK_Employees_Departments)).DepartmentName FROM TestLib.Employees AS p;
Show Correct Answer
Source: MeasureUp.Com | |
Alert Moderator