dear sir,
i am trying to create view with following query
create view salesQ as
select * from sales, customer where sales.customerkey
= customer.customerkey;
it is giving
ERROR: column "customerkey" duplicated
create view salesQ as
select sales.*, customer.* from sales, customer where
sales.customerkey = customer.customerkey;
also giving same error.
i cannot change field names or specify field names in
view definition because many fields are there in both
tables. how to create this view?
thanks in advance,
-Simon Moses,
Bangalore, India.
=====
**************************
Visit My Home Page
http://www.geocities.com/ks_moses
updated: 28 Sep 2004.
Simon Moses
**************************
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com