Re: create view problem

On Sun, 17 Oct 2004, Simon Moses wrote:

> dear sir,
> i am trying to create view with following query

This has nothing to do with JDBC or Java, so it should not be sent to the
JDBC list.

> 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?
>

You need to use aliases in your SELECT...

SELECT sales.customerkey AS salescustomerkey, customer.customerkey AS
customercustomerkey, ... FROM sales, customer WHERE ...

Kris Jurka