<div dir="ltr"><div><pre><span class="">Hello, if I have this query (from the docs)<br></span></pre><pre><span class=""><br>select</span><span class="">((</span><span class="">p</span><span class="">,</span> <span class="">c</span><span class="">)</span> <span class="">for</span> <span class="">p</span> <span class="">in</span> <span class="">Person</span> <span class="">for</span> <span class="">c</span> <span class="">in</span> <span class="">p</span><span class="">.</span><span class="">cars</span> <span class="">if</span> <span class="">c</span><span class="">.</span><span class="">make</span> <span class="">in</span> <span class="">(</span><span class="">"Toyota"</span><span class="">,</span> <span class="">"Honda"</span><span class="">))</span></pre><br></div>How can I have p be distinct, while c is not distinct?<br><br><pre><span class="">select</span><span class="">((distinct(</span><span class="">p)</span><span class="">,</span> <span class="">c</span><span class="">)</span> <span class="">for</span> <span class="">p</span> <span class="">in</span> <span class="">Person</span> <span class="">for</span> <span class="">c</span> <span class="">in</span> <span class="">p</span><span class="">.</span><span class="">cars</span> <span class="">if</span> <span class="">c</span><span class="">.</span><span class="">make</span> <span class="">in</span> <span class="">(</span><span class="">"Toyota"</span><span class="">,</span> <span class="">"Honda"</span><span class="">))<br><br></span></pre><pre><span class="">doesn't seem to work.<br><br></span></pre><pre><span class="">Thanks!<br></span></pre><br clear="all"><div><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Regards,<br><br>Matthew Bell<br></div>
</div></div>