5 Replies Latest reply: Sep 16, 2017 5:44 AM by vir vir RSS

    want to set when one date should not have any matching interval in from date and to date in different table

    vir vir

      Hi All,

       

      I having one requirement where i have 2 tables.

       

       

      Online Booking :

      Online Booking Date,

      Online Arrival Date,

      Online Booking ID

      ;

       

      Physical Arrival Table:

      Arrival Date,

      Departure Date;

       

       

      I want the number of record from Online Booking table , where Online Arrival Date don't have any presence in between Physical Arrival Date.Arrival Date and Physical Arrival Date.Departure Date column.

       

      simply i want the count of booking from online which don't have any arrival in physical arrival table.

       

      even we can set a flag also in Online booking table.

       

      please suggest the correct scenerio.