![]() |
|
![]() |
![]() |
Archives of the TeradataForumMessage 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. Craig Craig Ferry WESCO Distribution, Inc.
| ||||||||||||||||||||||||||||||||||||||||||||||
https: | ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
![]() | ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 28 Jun 2020 | ||||||||||||||||||||||||||||||||||||||||||||||||