Dick:
UNION tblName1
WITH tblName2
FORMING [TEMP] tblName3
USING [columnList]
[] indicates "optional"
See: www.rbase.com/support/rsyntax/rbgx5.union.html
... for the support text.
You might consider PROJECTing the table with the non-matching column
names to a temp table with columns renamed to match; being mindful that
datatypes and column definitions must match.
Hope this helps.
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
[email protected] | +011 (909) 238-9012 c | +011 (909) 912-8678 f
------ Original Message ------
From: "Dick Fey" <[email protected]>
To: "RBase Maillist" <[email protected]>
Sent: 7/15/2021 11:34:12 AM
Subject: [RBASE-L] - Append
Seems that I recall a way to append one table to another, using an alias when
the column names do not match,
but can't find it in help.
Ideas?
Dick Fey
-- Carpet Broker Inc
P-913-894-9211
F-913-894-0138
-- 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/70c057f1-1100-48d3-148f-84d7f822aebf%40carpetbroker.com.
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emb9f100bb-cb50-4a93-b285-ff9d1a21a286%40pathfinder.
