Did you look in the SQL help file?
--- On Wed, 12/30/09, Damon Theis <[email protected]> wrote: From: Damon Theis <[email protected]> Subject: [delphi-en] Old BDE sql help To: "delphi...@yahoogroups. Com" <[email protected]> Date: Wednesday, December 30, 2009, 5:00 PM Not sure why this is giving me fits, but I just want to insert some data from one table to another based on where clause. insert into labels(cost) select worktable(cost) from worktable where labels.upc = worktable.upc I get capability not supported in the database desktop app. -thanks. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
