Thank you, Dan. All columns exist in both tables.
Bruce
------ Original Message ------
From "'Daniel Goldberg' via RBASE-L" <[email protected]>
To "[email protected]" <[email protected]>
Date 12/16/2024 1:27:12 PM
Subject RE: [EXTERNAL] [RBASE-L] - UNION Fail
Is one of the using columns in both tables?
USING collist
Specifies the columns and order of columns that you want to include in
the new table. At least one column in the USING clause must exist in
both tables. If you do not include the clause, R:BASE makes a new table
that includes all columns from both tables.
Dan Goldberg
From: [email protected] <[email protected]> On Behalf Of
Bruce Chitiea
Sent: Monday, December 16, 2024 11:45 AM
To: [email protected]
Subject: [EXTERNAL] [RBASE-L] - UNION Fail
All: RGB11
Can't say I've ever seen this. This UNION structure outputs a table
containing only the contents of tableName1_tt (production table names
changed for this discussion):
UNION tableName1_tt +
WITH tableName2_tt +
FORMING TEMP tableName3_tt +
USING +
line0_entityID, +
line1_addressee, +
line2_streetAddress, +
line3_cityStateZip
Of note:
- no error message is thrown
- all three tables are temp tables
- all production table names are legally formed
- tableName1_tt and tableName2_tt have the same number of columns
- column names are the same, arranged in the same order, in both tables
- each set of named columns has the same datatype
- both input tables are generated without error
- tableName3_tt contains only the rows from tableName1_tt
Syntax:
UNION tableName1 WITH tableName2 FORMING TEMP tableName3 USING colList
Huh. Should be childs-play. Any thoughts? And thanks.
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<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 visit
https://groups.google.com/d/msgid/rbase-l/em77665026-a5d8-450b-a3b0-3dfaee82dbfe%40a413b759.com
<https://groups.google.com/d/msgid/rbase-l/em77665026-a5d8-450b-a3b0-3dfaee82dbfe%40a413b759.com?utm_medium=email&utm_source=footer>.
--
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 visit
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027507509D2B35245052B32D43B2%40BY3PR19MB5027.namprd19.prod.outlook.com
<https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027507509D2B35245052B32D43B2%40BY3PR19MB5027.namprd19.prod.outlook.com?utm_medium=email&utm_source=footer>.
--
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 visit
https://groups.google.com/d/msgid/rbase-l/em14e429b9-4d8a-4d47-a0dc-b5e79386d804%40a413b759.com.
