• Bhoomi Patil
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 1
    Replies

I m trying to query two fields from two different custom objects with 'where'  condition.
Scenario:ObjA--> Customer name , customer Code
ObjB--> Invoice Number 
Conditon: want to display all the customer names and  code who has Invoice number .
Note:ObjB field exist in the quick action of ObjA

So Far i've written the query below
select id,customerName and Customer_code ,(select id,Invoice_number from  ObjBs__r) from opportunity --> here all the customername and customer codes are getting displayed . But am looking for only those customer names whose invocie number are attached to this it. 

Thanks in advance