Emp_Pat_Dept_Data is the name created with the create view, so you should be able to use it in SQL commands.
If you use that view you will only see the fields in the view’s field list
The fields will have the field names assigned in the view.
Well, I don’t know why it wouldn’t support the long name.
Doesn’t seem that hard for you to try it…or google it…becoming a bit too dependent.
Let us know the answer.
cool-thanks for the feedback.