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 issues column to the outer select; it should 
have read:

select M.title, SubscriptionVariants.issues
from Magazine as M
join
(
select distinct issn, issues from subscription
) as SubscriptionVariants

on SubscriptionVariants.issn = M.issn
order by M.title, SubscriptionVariants.issues


Regards
Tim Romano


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to