Hi,

I have two unrelated objects where a specific column might have the same value in another object. I'm trying to find out if a value in an object, already exist in another object. I was reading up on a wrapper classes, but I couldn't get my head around it. Any idea how this is possible? 

For example I have the following two objects with the following fields

Object_1__c (id, Name, Status)

Object_2__c(id, Name, Area)

In SQL, it would be written something like below. Please NOTE that there are fields that need to be displayed from both objects.

SELECT o1.id, o1.Name, o1.Status, o2.Area FROM Object_1__c o1, Object_2__c o2 WHERE o1.Name = o2.Name