Which SOQL query wr...
 
Notifications
Clear all

Which SOQL query wrii return a unique list of all the Contact records that have no Fulfilled Orders?

1 Posts
1 Users
0 Likes
50 Views
Tuan
 Tuan
(@shippertuan)
Noble Member
Joined: 7 months ago
Posts: 366
Topic starter  

A company has a custom object. Order__c, that has a custom picklist field. Status__c, with values of New, In Progress," or Fulfilled and a lookup field, Contact_c, to Contact.

Which SOQL query wrii return a unique list of all the Contact records that have no Fulfilled Orders?

  • A . SELECT Contact_c From order_c Where id NOT IN (SELECT id FROM_c Where States_c + Fulfilled')
  • B . SELECT iD FROM Contact WHERE id NOT IN (SELECT id From order_c WHERE_c = Fulfilled')
  • C . SELECT Contact_c FROM Order_c Where Status_c <> ;Fulfilled'
  • D . SELECT id FROM Contact WHERE id NOT IN (SELECT Contact _c FROM order_c Where Status_c = fulfilled')

Show Answer Hide Answer

Suggested Answer: D

   
Quote
Share: