>Hilmar:
>
>How can I save the result of this query in a new table?
To the SELECT statement, you add:
... INTO CURSOR MyCursor
to create a cursor (temporary table), that will be erased as soon as you close it (USE IN MyCursor),
or:
... INTO TABLE MyTable
to create a permanent table (which won't be automatically erased).
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)