1-9.sql

这是一个数据库课程设计的sql语言

select distinct cno
from   sending,nmtable
       where sending.nmno=nmtable.nmno and nmtable.title='人民日报'
       group by cno
       having count(distinct issue)=(select count(distinct issue)
                                   from sending,nmtable
                                   where sending.nmno=nmtable.nmno and nmtable.title='人民日报')