Archives of the TeradataForum
Message Posted: Wed, 11 Jun 2008 @ 22:09:16 GMT
Does anyone know how to do the following. I can't think of a simple way to do this, but hopefully I'm overlooking something.
Here is a visual example. My real data is millions of records of sales data totally unrelated to example :-).
Table_A (next line column headings) - in real table, about 3.5 million records
Animal Color PetStoreID dog black 777 cat white 888 dog brown 999
Table_B (next line column headings) - in real table, about 1 million records
Comment PetStoreID I sold the white cat 111 cat black ran away 111 br_own is the dog color 222 do-gbla-ck is sick 222
'Generically' I would need to do something similar to the following. I also need to do cleanup of the comment column, but I can do that in a prior step.
WHERE table_b.comment LIKE table_a.animal AND table_b.comment LIKE table_a.color AND table_b.PetStoreID <> table_a.PetStoreID
My output needs to be a merge of data from table a and table b.
Thanks in advance for any thoughts.
WESCO Distribution, Inc.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|