Problems with VIEWs
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,