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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org