• Jotsna Gowda
  • 0 Points
  • Member since 2019

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 1



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