title: MongoDB Compass: How can I perform a SQL join / Mongoose populate?
body: <p>I have a collection called <code>Post</code>, which has an ID field called <code>makeupProduct</code>. This ID field is a foreign key to my <code>MakeupProduct</code> collection.</p>
  
  <p>In MongoDB Compass, I'm trying to find all Posts</p>
  
  <ol>
  <li>where <code>productUrl === null</code> and </li>
  <li>populate the Makeup record along with it</li>
  </ol>
  
  <p>Is this possible?</p>
  
  <p>I have the 1st filter down, but don't know how to write the rest.</p>
  
  <p><a href="https://i.stack.imgur.com/pz75R.png" rel="noreferrer"><img src="https://i.stack.imgur.com/pz75R.png" alt="enter image description here"></a></p>