help with DataModel

[fabdulazeez]

 I have 2 tables.

1 with schedule for the salesman 

smcode	day	custcode
101	Sunday	xcdddd
101	Sunday	xcddee

2 with actual route

smcode	day	date	custcode
101	Sunday	23-Jun	xcdddd
101	Monday	24-Jun	xcsssss

Salesman can go to any customer. What will be the best way to join the tables.

 When i select date i need to know

1)customers not visited

2) Customers visited extra

3)Customer visited as per schedule.

[fabdulazeez]

So i joined the schedule table with master calendar, to build schedule for every date.

than  that was joined with actuals.

Thanks for your support and time