Maybe I'm missing the point, it is early.

>Create 2 tables having Employee_no in both tables.
>Create a view linking these two tables on the Employee_no columns.
>Select only the Employee_no column from Table 2 as output in the view.
>
>I am unable to determine what table the Employee_no output field is coming from.

Seems to me that the value is coming from table2.employee_no since you've stated that it is the only on in the column list of the view.

Am I missing something?

-Mike