So I have two tables; tblAppDetail and tblMainCustInfo. I need to update one column (Appt_Sidemark) between these two tables. tblApptDetail has field called: Appt_Sidemark and tblMainCustInfo has field called: Sidemark.
These two tables has CustID Linked.
When I try the following SQL, I am getting
1: Unexpected token: in statement [update "tblApptDetail" set "tblApptDetail"."Appt_Sidemark" =]
Here is what I am running at TOOLS–>SQL
update “tblApptDetail” set “tblApptDetail”.“Appt_Sidemark” =
(select “tblMainCustInfo”.“Sidemark” from “tblMainCustInfo” where “tblApptDetail”.“CustID” = “tblMainCustInfo”.“CustID”)
where exists
(select “tblMainCustInfo”.“Sidemark” from “tblMainCustInfo” where “tblApptDetail”.“CustID” = “tblMainCustInfo”.“CustID”)
I know it is me…just not smart enough to figure it out by myself.
So your kind help is greatly appreciated.