[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