This content has been marked as final. Show 5 replies
I having one requirement where i have 2 tables.
Online Booking :
Online Booking Date,
Online Arrival Date,
Online Booking ID
Physical Arrival Table:
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.