Join 2 unrelated objects based on field? Wrapper Class?
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