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
---
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.
