Problems with views

Started by mazzoalmost 25 years ago1 messagesgeneral
Jump to latest
#1mazzo
jambo@aruba.it

Hi all..i'm trying to create some views on which i have to execute some queries...the problem is that i get errors saying that a field has already been specified..To make it more clear: i have a table called testing with these fields..a b c d e..I created 1 view like:

create view one as
select a,c,e from testing where a <100

and this one works fine...
If i try to create another view eg:

create view two as
select * from testing

I get the error that i mentioned above..saying that a field c has already been specified...

Is there a solution??

Thanks in advance!