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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
selecting from 2 tables w/dup keys
Thanks, but I'm strictly selecting to determine the problem ZIPs. The code that performs the initial inserts is being addressed separately. -
selecting from 2 tables w/dup keys
Table 1 - ID DATE ZIP USER_ID 111 6/1 11111 003 111 6/1 11111 708 Table 2 - ZIP RTE DATE USER_ID 11111 1 6/1 003 11111 1 6/1 708 Key on Table 1 is ID, DATE Key on Table 2 is ZIP, RTE, DATE Dup key rows were...
