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]<mailto:[email protected]> (909) 238-9012 m -- 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]<mailto:[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.
