From: | Simon Moses <ks_moses(at)yahoo(dot)com> |
---|---|
To: | pgsql general <pgsql-general(at)postgresql(dot)org>, pgsql jdbc <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | create view problem |
Date: | 2004-10-18 05:36:31 |
Message-ID: | 20041018053631.80052.qmail@web14924.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2004-10-18 05:42:01 | Re: [JDBC] create view problem |
Previous Message | Joel | 2004-10-18 05:09:49 | Re: OS X Install |
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2004-10-18 05:42:01 | Re: [JDBC] create view problem |
Previous Message | Oliver Jowett | 2004-10-18 02:02:11 | Re: setBinaryStream can abandon connection |