I had responded to Jean-Denis Muys as follows:
> select M.title
> from Magazine as M
> join
> (
> select distinct issn, issues from subscription
> ) as SubscriptionVariants
>
> on SubscriptionVariants.issn = M.issn
> order by M.title, SubscriptionVariants.issues
>
>
But I neglected to add the
Your requirement is not quite clear to me: " I want the number of issues
in a subscrpition for each magazine". The magazine whose id is n086 has
two subscriptions in your example. Is it possible for a given magazine
to have subscriptions with a different number of issues? E.g. a one-year
2 matches
Mail list logo