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

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

    virendra chawra

      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.