我通过使用3个表执行查询生成报告,我需要在新页面上开始每个日期,但所有行都位于其他行的底部
如何将任意日期的行拆分到新页面
select PM_Report.*,PM_Scores.*,PM_Table.* from PM_Report left outer
join PM_Scores on PM_Report.date=PM_Scores.date and
PM_Report.period=PM_Scores.period left outer join PM_Table
on PM_Table.row=PM_Scores.row and PM_Table.period=PM_Scores.period
where PM_Table.period='daily' and PM_Report.date between
'2015/05/01' and '2015/05/05' order by PM_Report.date