[EMAIL PROTECTED] 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.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to