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
