string sql = @"
select top 6 a.ID,Title,a.CreateDate from Office_Notice a,Office_NoticeType b
where a.TypeID=b.ID and b.Type='重要通知' order by a.CreateDate desc;
select top 6 a.ID,Title,a.CreateDate from Office_Notice a,Office_NoticeType b
where a.TypeID=b.ID and b.Type='学习培训' order by a.CreateDate desc;
select top 5 ID,Matter as Title,CreateDate from Office_AvisoMain order by ID desc;
select top 5 ID,Title,AddDate as CreateDate from Inform_BBS order by ID desc;
select top 6 a.ID,Title,a.CreateDate from Office_Notice a,Office_NoticeType b
where a.TypeID=b.ID and b.Type='财务通告' order by a.CreateDate desc;
select top 6 a.ID,Title,a.CreateDate from Office_Notice a,Office_NoticeType b
where a.TypeID=b.ID and b.Type='客服通告' order by a.CreateDate desc;
select top 5 * from Utility_URL;
select ID,EmpName from Organ_Employees where del_flag=0;
select top 5 * from Office_CodeUrl order by Order_id";数据库连接ACCESS,上面是SQL语句,不知道ACCESS的一条SQL语句支持多个SELECT不?请各位专家帮助~~~~
select top 6 a.ID,Title,a.CreateDate from Office_Notice a,Office_NoticeType b
where a.TypeID=b.ID and b.Type='重要通知' order by a.CreateDate desc;
select top 6 a.ID,Title,a.CreateDate from Office_Notice a,Office_NoticeType b
where a.TypeID=b.ID and b.Type='学习培训' order by a.CreateDate desc;
select top 5 ID,Matter as Title,CreateDate from Office_AvisoMain order by ID desc;
select top 5 ID,Title,AddDate as CreateDate from Inform_BBS order by ID desc;
select top 6 a.ID,Title,a.CreateDate from Office_Notice a,Office_NoticeType b
where a.TypeID=b.ID and b.Type='财务通告' order by a.CreateDate desc;
select top 6 a.ID,Title,a.CreateDate from Office_Notice a,Office_NoticeType b
where a.TypeID=b.ID and b.Type='客服通告' order by a.CreateDate desc;
select top 5 * from Utility_URL;
select ID,EmpName from Organ_Employees where del_flag=0;
select top 5 * from Office_CodeUrl order by Order_id";数据库连接ACCESS,上面是SQL语句,不知道ACCESS的一条SQL语句支持多个SELECT不?请各位专家帮助~~~~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货