SQL Update query producing syntax error
Posted on 2007-03-19
I have the below query:
UPDATE insurance_details_tbl, order_details_tbl
SET insurance_details_tbl.order_id = order_details_tbl.order_id
WHERE order_details_tbl.order_id = insurance_details_tbl.order_id;
Should be quite obvious what i'm attempting to do. But I am getting "Syntax Error Line 1 produced near ',' ".
Could someone provide me with the correct syntax. Thanks.