Re: Problems with VIEWs

Your select can't possibly work fine alone without a "group by something" clause. marcus@balu.sch.bme.hu (Mohos Csaba Mark) wrote: :I've problems with VIEWs. I've created a VIEW: : :CREATE VIEW something (title, number) AS :SELECT somebody, COUNT(any) :FROM book, lending :WHERE book.isbn = lending.isbn : :The SELECT statement works fine alone. If I create the VIEW, DbAccess :returns View Created. I make a query from this VIEW : : :SELECT * :FROM something : :I get a syntax error! : :Anybody knows the reason of the problem?? : :Please mail Me : marcus@balu.sch.bme.hu : :Thanx in Advance :Bye, : Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org