select SUBMISSION_PERIOD_SID,dfsi.customer_sid,sp.submission_schedule_sid from DATA_FILE_SUMMARY_INFO dfsi right join submission_period sp on dfsi.SUBMISSION_PERIOD_SID = sp.sid order by SUBMISSION_PERIOD_SID asc;