>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.
If it's not broken, fix it until it is.
My Blog