title: Need Help for Join tables in Linq on ASP.NET Core
body: <p>basically i am working on ASP.NET Core and I have an FromSqlRaw statement which filters and keeps some ids in a value of a talbe (ActiveCalls).
  Then with Linq I filter another table of database (AppUsers).
  My goal is to keep all columns of Appusers with Ids i take from ActiveCalls.</p>
  <p>Code for SqlRaw with Ids result : (13) Correct!</p>
  <pre><code>var results = _context.ActiveCalls.FromSqlRaw(&quot;SELECT web_userid from ActiveCalls where TimeReceived&gt;'2021-01-01' and GeoX &gt; 23.8097593342164 and GeoX &lt; 23.8838031312548 and GeoY &gt; 38.1026672246045 and GeoY &lt; 38.1607577524088 group by web_userid&quot;);
  </code></pre>
  <p>Code for Linq with data :Result (2281) Correct!</p>
  <pre><code>appusers = appusers.Where(s =&gt; s.LastCall &gt;= start &amp;&amp; s.LastCall &lt;= end);
  </code></pre>
  <p>Code for Join tables to keep only Records of AppUsers based on Ids i found on ActiveCalls. Result(10) Wrong!</p>
  <pre><code> appusers = from res in results
                       join ap in appusers
                       on res.web_userid equals ap.Id
                       select ap;
  </code></pre>
  <p>I have to take the result with Linq and those 3 steps and not merge all in on Sql query</p>