Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 11 Jun 2008 @ 22:09:16 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Partial field comparison
From:   Ferry, Craig

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 Ferry
Sr. Database Administrator

WESCO Distribution, Inc.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020