I have two tables with structure
Table1 ------ No | Name | IDNo | HouseNoBlock Table2 ------ IDNo | HouseNo | Block
I am trying to update the
HouseNoBlock Column of first table with value joined by
HouseNo/Block while comparing the
IDNo . I was able to get the values using the query
SELECT CONCAT(table2.HouseNo,'/',table2.Block) FROM table2 ,table1 WHERE table1.IDNo = table2.IDNo
but when I try to
UPDATE table1 I am getting a
Syntax error ERROR 1064 (42000) .
UPDATE table1 SET HouseNoBlock = CONCAT (table2.HouseNo,'/',table2.Block) FROM table2 ,table1 WHERE table1.IDNo = table2.IDNo
Can somebody help with this?