Subject Re: [ib-support] join RDB$DATABASE
Author Milan Babuskov
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