I created a view that joins two tables (tblOrder and tblProduct). The field
ProductID is common to both. When I save the View I get the following error
message: "Column names in each view must be unique." Is there a way around
that? Should I be naming my Key Fields and Foreign Key fields differently?
I'm new to MS-SQL. Thanks for your help.
Louis