>How can I merge two tables?
>I tried to merge two tables(thier sturctures are identical) with the command "union" but it failed.
>I got an error message which says the memo file(ftp) is missing.
>
>Thanks,
>Tamas
Memo file is FPT :-)
use UNION ALL instead.
When you use just union SQL Engine tries to filter duplicated records this operation is invalid for Memo, BLOB etc. fields.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.