First you will need to create an for the manager’s external element name. Usually an external element is used to access data from another table, but in this case it is used to access a different row in the same table. You will create the external element, MGR_NAME, which lets you obtain the manager’s name by connecting the MANAGER element to the EMP_SSN element. To create the MGR_NAME external element: | Highlight the <Edit> option and press [enter]. | Press [insert] to add a new element. Press [enter]. | Type MGR_NAME for the new element name. | Select EXTERNAL as the element type. Create an external element
First you will need to create an external element for the manager’s name. Usually an external element is used to access data from another table, but in this case it is used to access a different row in the same table. You will create the external element, MGR_NAME, which lets you obtain the manager’s name by connecting the MANAGER element to the EMP_SSN element. To create the MGR_NAME external element: | Highlight the <Edit> option and press [enter]. | Press [insert] to add a new element. Press [enter]. | Type MGR_NAME for the new element name. | Select EXTERNAL as the element type. Create an external element
_new_ezq_reference.docx