Jul 20, 2005 #1 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
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
Jul 20, 2005 #2 Blorf Programmer Dec 30, 2003 1,608 US 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. Upvote 0 Downvote
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.