Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ACCESS - 2 tables with dates

Status
Not open for further replies.

JJeremy

Technical User
May 27, 2005
10
US
Hello All,

Table1 have ad dates and Table 2 have all dates. I want to exclude the dates from Table1 from Table2. How do I do that?

Thanks and please help.

JJeremy

Analyst
Lakewood, CA
 
Left join on the date fields from 2 to 1, and say is null on table 1's date.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top