miken32 wrote:
> If you could suggest a way to get a count in there (so I could spot
> episodes with more than one airing and flag them) it would be wonderful.

If I were doing this application, I would do the count in a separate
query.

In general, it's not efficient or appropriate to do too many things in a
single SQL statement. Sometimes it is possible to do so, but it's
likely to involve contortions that make your code difficult to maintain.

Regards,
Bill K.