spam_eater@gmx.net says...
> Paul Ganainm schrieb:
> FB does not support inline views/derived tables, e.g.:
> SELECT count(*) FROM (SELECT col1, col2 FROM table)
If you have IB/FB, there is a sample db that comes with it, Employee.
There is a view in that db called phone_list.
I did select count(*) from phone_list and it worked.
Paul...
> Thomas
--
plinehan x__AT__x yahoo x__DOT__x com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.