I have three different tables that all have a timestamp field (YYYY-MM-DD hh:mm) which are in the same range. I'd like a user to be able to show data based on this timestamp field with the date picker tool. I've search a lot and always comme across creating a master calendar. This method is based off the idea that different tables have a common field (for example OrderID). However, the three tables that I'm working with have no fields in common (other than the timestamp).
TableA: A_ID, timestamp, other fields
TableB: B_ID, timestamp, other fields
TableC: C_ID, timestamp, other fields
How can I select data from these three tables at the same time with the date picker tool?
