First date within 2 tables

[shophoney]

Hi I have 2 payroll tables MAIN and MGMT. They both have dates and are linked to a common calendar table.

I would like to know the first date you were paid from both tables.

You could only show up on the MAIN or MGMT or both.

Is this possible?

thanks

 

[RasGhul]

Can you post some sample data?