sorry for the confusion (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22755932.html
i will try to explain one more time:
table 1 = t1 has columns c1, c2, c3, c4, and c5
table 2 = t2 has columns c1, c2, c3
table 3 = t3 has columns c1, c2
t1.c1 corresponds to t2.c1 that is t1.c1 is populated with ABC1,ABC2,ABC3..etc. while t2.c1 is populated with ABC1, ABC1, ABC2, ABC2, ABC3 , ABC3. there are to rows/entries in t2 for every entry in t1.
column c3 of table2 is populated with XYZ1, XYZ4, XYZ1 ,XYZ5, XYZ1, XYZ10. column c2 of table3 is populated with XZY1,XYZ2,ZYZ3, ... XYZN (all avaialble enetries)
i need to updated table2.c2 with table3.c1 in case when
table1.c4 = 'Val1' and table1.c5 = 'val5'
and table1.c1 = table2.c1
and table2.c3 =table3.c2