Combining DateFields from different tables.

[#1]

Hello,

I'm currently working with some database, that have and arrival table and a departure table, each with the field DATE.

They both in same format, and so i didnt have them as a syntetic key, i rename as DateA and DateD.

At the end of my script, im creating a Master Candelar, wich divides by quarter, weeks, etc.

I usually use only one Date in one table. What i do first is get the max and min date to know the range of dates im creating.

It usually goes likes this:

load

Max(PostingDate) as MAX_DATE,

Min(PostingDate) as MIN_DATE

Resident [Account Document Header];

Now, i need to do that but with 2 different date fields from 2 different tables.

To determine the max or min its just a simpe if, but i dont know how to extract form 2 different tables.

Any Ideas?

thanks.

[Gysbert_Wassenaar]

See this document and the comments: Tutorial - Using Common Date Dimensions and Shared Calendars