If I have 2 tables A and B.

In table A, there is identity dealID, and there are columns col1, col2, col3, col4, in fact col1, col2, and col3 together can be identity too.

In the table B, I have bID as identity, col1 refer col1 in A, col2 refer col2 in A, dealId refer dealId in A, and col5,col6 dont referrer anything

Now I want to update the last row of Bs dealId according to known value col1, col2, col3 in A, col6 in B


I could write 2 query to accomplish it:
Select A.dealID from A inner join B on A.col1 = B.col1 and A.col2 = B.col2 where A.col3 = xxx and col6 = xxx
Set rs = Con.execute strsql

update B set B.dealID = rs.fields(0) where dmax(bid, B)


does anyone know can I write this update query into one? Or I have to write as the two. Thanks a lot