Syntax help?

[gilly]

I need help with a SQL statement.
I need to update TWO tables in one go! The two tables are called tbl_ManifestDet and tbl_Accounts.

Here is my statement below. Currently it updates my first table called tbl_ ManifestDet with a dexcode and AccountNo. I need to update the field called "manifested" & set it to "N" in another table called tbl_Accounts. How do i write this?

strSQL = "UPDATE tbl_ManifestsDet SET dexcode = '" & reason & "', manifested = 'N' WHERE AccountNo = '" & Mem(SockNr) & "'"
            adoConn.Execute strSQL

[THEROB]

You can also try this:

strSQL = "UPDATE tbl_ManifestsDet mD, tbl_Accounts A SET mD.dexcode = '" & reason & "', mD.manifested = 'N' WHERE A.AccountNo = '" & Mem(SockNr) & "'"
adoConn.Execute strSQL


You do need to link the tables - so where A.id = mD.id or whatever link is there

[gilly]

Can i do Innerjoin?

I havent used it before? Can anyone help write it?

thanks

[THEROB]

How do the tables link?

If you are using access - you can use the tool to generate the sql

R