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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Comparing tables
I have 2 tables (A and B). A has 3 fields (City, State, Phone) and B has 2 (City, State). I need to find records that exist in A but not B, ignoring the Phone field, since it doesnt exist in table B. For instance: [code] Table A: City | State | Phone -----------------------------------... -
Comparing tables
I have 2 tables (A and B). A has 3 fields (City, State, Phone) and B has 2 (City, State). I need to find records that exist in A but not B, ignoring the Phone field, since it doesnt exist in table B. For instance: Table A: City | State | Phone -----------------------------------...- daevux
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Comparing tables, finding unique records
I have 2 tables (A and B). A has 3 fields (City, State, Phone) and B has 2 (City, State). I need to find records that exist in A but not B, ignoring the Phone field, since it doesnt exist in table B. For instance: Table A: City | State | Phone -----------------------------------...- daevux
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
IIS, ASP, XML - how do I disable caching?
I have an ASP page (run locally) that works as a portal. It shows details about my filesystems (freespace, etc), date/time, quicklinks, email, Slashdot stories (just headers - with links to slashdot.org), etc. The Slashdot headers are generated by parsing XML pulled directly from slashdot.org...- daevux
- Thread
- Replies: 0
- Forum: Microsoft: Windows servers
