Question

please help on writing a query for updating two table with one query

Answer 1

i have tried this $query = "UPDATE projects, customersnewlist SET projects.SDPM_ref = '" . $SDPMRef . "',projects.BSCPriorityAdj = '" . $bscprior . "',projects.CMSSAI = '" . $cmssai . "',projects.Clarify_No = '" . $opNum . "',projects.Date_CRD_received = '" . $dateRecieved . "', customersnewlist.CustomerName = '" . $customer . "' WHERE projects.SDPM_ref =" . $SDPMRef;

Answer 2

I don't think that you can actually update 2 tables with the same query. You can use a join in an update query to update one table based on another, but you can only actually update a single table at a time. One way around this limitation though, is using triggers. If the update to the second table is done using data from the first, and you want it done every time the update is done on the first, you can add a trigger on the table that either updates the second table directly and automatically, or that calls a stored procedure that can use logic to determine whether or not to update.