var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: another update sql statment
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 don’t referrer anything
Now I want to update the last row of B’s 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