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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by steveevets
-
a simple update, inner join statement??? or NOT
and ps - the where statement is actually: WHERE kl.keyword=wkl.keyword And kl.[site name]=wkl.[site name]; ** using the aliases- steveevets
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
a simple update, inner join statement??? or NOT
I am trying to perform what seems like a simple query using Access (Office 2000); as follows; UPDATE wrk_keylist AS wkl INNER JOIN keylist AS kl ON kl.[list #] IS NOT Null SET wrk_keylist.[old list #] = keylist.[list #] WHERE keylist.keyword=wrk_keylist.keyword And keylist.[site...- steveevets
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
