Archives of the TeradataForum
Message Posted: Tue, 16 Jan 2001 @ 21:35:52 GMT
I'm running into a strange problem when using a multi insert table. Sometimes it doesn't extract any rows from one of the selects. Has anyone else had this problem?
Here's an example:
Insert into database1.target_table
Table is empty before the query begins.
Rows inserted is 20.
Unfortunately, there are 20 rows in source1_table and 30 rows in source2_table. There are no duplicates.
Where did my 30 rows go????
Any help would be appreciated.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|