Hi Aleks,
>It is possible to do initial selection of data by a command COPY TO, which sees all changes. But can there is the way easier and main faster (that not strongly braked SQL)?
You need to issue a TableUpdate to get those records into your SQL.
If you are looking for newly added records you could also use a SCAN-ENDSCAN and loop through the buffered alias checking for RECNO() < 0.
If you want all the buffered records, create a temporary cursor and loop through the buffered alias with SCAN-ENDSCAN and Insert records into the temporary cursor. Now you can run the SQL against this temporary cursor.
Not a great way of solving the problem but they'll work. <g>