help!
query is equivalent to "update table1 set field6 = (select table2_field2
from table2 where table2_field5 = table1.field5)"
table2 appears to have many instances of table2_field5.
my question is, how do i reformulate my SQL so that i can update table1 such
that it only gets the first occurrence of table2_field5 on table2 and ignore
all the other occurrences? is there even a way where only 1 SQL statement
is sufficient to carry out the desired result(s)?
thanks in advance!!!
i hope i stated my question clearly, sorry if i didn't.
mel