ronaldorezende wrote:

> See my sql:
>
> select field1, field2, current_date from table1, RDB$DATABASE
>
> Why the result is not a join of the two tables?

It is. RDB$DATABASE has only one row, and you haven't selected anything
from it. You don't need RDB$DATABASE if you have some other table.

If you _only_ want to get server date, then you must select from something:

SELECT CURRENT_DATE FROM ...table name is required...

RDB$DATABASE is good for this since it has only one row. You can select
from any other table too. CURRENT_DATE is not a column u RDB$DATABASE.


--
Milan Babuskov
http://fbexport.sourceforge.net