create view problem

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