Anne,
Here's how ...
APPEND tablename1 TO tablename2 WHERE SoNum IN (SELECT SoNum FROM
anytable WHERE ...)
You may also select columns using the INSERT command as follows:
INSERT INTO tablename2 +
(column1, columns2, columns3) +
SELECT column1, columns2, columns3 +
FROM table1 WHERE SoNum IN (SELECT SoNum FROM anytable WHERE ...)
Take a look at the APPEND and INSERT syntax for more details ...
HELP APPEND
HELP INSERT
Hope that helps!
Very Best R:egards,
Razzak
At 08:53 AM 12/28/2017, a...@redcaptransport.com wrote:
With append can you do the following, or is the sub-select good form?
append sotabl to socltbl using * where sonum = any (sub-select sonum
from invtabl)
Had just projected a new table.
With the append command want to include all the sonum based in the invtabl.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.