select ss.sid as ss_sid,sp.sid as sp_sid,ss.customer_sid from submission_period sp join submission_schedule ss on ss.sid = sp.submission_schedule_sid;