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!
