>Naomi,
>
>"I see that I forgot to group by Serial, but you still should have get results for all serials in your table, since I used left join from Data to something."
>
>How about " I see that I forgot to group by Serial, but I'd still expect my query to return all Serials in the table because of the Left Join from Data to something".
>
>If you insist on using "got" then you could use "have got" but it's clumsy.
>
>Also fwiw I'd consider dropping the last sentence in the quote you provided or at least softening it to a query in which case you could drop the first sentence. JMHO.

Thanks, John. This seems to be perfect. I've corrected.