Database : MYSQL and MSSQL

Query

SELECT customreport_details.REPORTID'Report ID'

    , customreport_details.REPORT_NAME'Report Title'

    , customreport_folder.FOLDER_NAME'Folder'

    , task_input.EXECUTION_START_TIME'Schedule Start Time' FROM customreport_details

    LEFT JOIN customreport_folder 

        ON (customreport_details.FOLDER_ID = customreport_folder.FOLDER_ID)

    LEFT JOIN reportscheduletask 

        ON (reportscheduletask.REPORTID = customreport_details.REPORTID)

    LEFT JOIN task_input 

        ON (reportscheduletask.INSTANCE_ID = task_input.INSTANCE_ID)