The only thing you CANNOT do is reference the same table in the sub-select (how many of us would love to be able to do that?)
IOW you cannot: append table1 to table2 where id not in (select id from table2) I'm sure everyone does what I do -- create a temporary view of the pertinent column from the destination table and use that in the sub-select Karen -----Original Message----- From: Jim Belisle <j...@kaypark.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Thu, Dec 28, 2017 10:13 am Subject: RE: [RBASE-L] - Append Question Anne, I would think any WHERE command that meets the proper syntax would be available to use with the APPEND command. James Belisle Making Information Systems People Friendly Since 1990 From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]On Behalf Of a...@redcaptransport.com Sent: Thursday, December 28, 2017 7:53 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Append Question 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. Thanks Anne Toni -- 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. -- 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.