We are in process of testing an application originally developed in ADO/Access 97 in ACCESS2000. I noticed the following behaviour on the following query :
UPDATE <table1> A
SET A.<COL1> = <some_value>
where
<table1>.Key = ( select <table2>.key
from <table2>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.