You are correct, I mistyped JOIN , it should be UNION for different tables

> btw:
> >> What did FlushBuffers do with an IB (or Fb) database?
>

According to Delphi Docs
--------------------------
Posts all changes that have been written to the record buffer.

procedure FlushBuffers;

Description

Call FlushBuffers to cause the dataset to post all pending changes to the
database, .including ...any cached updates. Use FlushBuffers instead of
...CheckBrowseMode if it is important that cached record buffers are posted.
------------------
So I put a procedure together that hopefully does about the same :)