Archives of the TeradataForum

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

WESCO Distribution, Inc.

	<Prev	Next>		<<First	<Prev	Next>	Last>>