Hi Christian,

These tables are created long back and there is flow where Files needs to be sent to client based on the Schedule in File_Schedule table. Currently they want to incorporate a missed notification of file which are not delivered as per schedule.

For that process, we thought of creating a table which will store all the daily schedule details along with Due time. For that purpose, we thought of Selecting all data from these three tables based on criteria for that day.

If there would have been only schedule type daily then we can use Join and select those data and insert them into Daily Schedule table. But as there are different schedule type and different Due_Day, so we are not able determine a select query which can select all the Daily Schedule for that day.

Please help me to generate a Select query which can determine all Daily Schedules for current Day which might fall in any of Schedule Type and Due_Day.

Thanks,

Khanin