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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]