Solution for data comparision

[ankitchauhan26]

Hello all, 

I need to find a solution for below issue:

• We are having 2 tables, in the first table there are 3 attributes (Hostname, Key, Value) and in the second table there are 4 attributes (Hostname, Date, Key, Value)
• We are merging the above two mentioned tables keeping Key as a primary key.
• And then, we are comparing Value attributes of both tables that they are the same or not.
• In the first table, we are getting in one row Value attributes Like { Apple,mango }, and in the second table, we are getting Value attributes like { Apple } or { mango }.
• We are comparing Value attributes on the bases of, if one value is the same for both tables then we consider that they are same.