Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
In this table both have any relation or not it seems there is no relation between they like Online Booking ID or some other fields check this in the Physical Arrival Table
Physical Arrival Table:
Arrival Date,
Departure Date;
Yes: Email field is common in both the tables.
Online Booking :
Online Booking Date,
Online Arrival Date,
Email,
Online Booking ID
;
Physical Arrival Table:
Arrival Date,
Departure Date,
Email;
Hi,
Try:
Count({$<[Online Arrival Date] = {"<[Arrival Date]"}>*<[Online Arrival Date] = {">[Departure Date]"}>}[Online Booking ID])
Cheers
Andrew
Not any unique ID like Online Booking ID or ID.
no.unique id.........
can we do it script.....
and generate non matching record..