Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Please help with update query to insert data into one table from another with matching criteria

Please help with update query to insert data into one table from another with matching criteria

Thread begun 1/19/2023 10:16 am by jo271221 | Last modified 1/23/2023 5:14 pm by Ray Borduin | 154 views | 1 replies |

1/19/2023 10:16 am | #1 jo271221

Please help with update query to insert data into one table from another with matching criteria

UPDATE table1 b INNER JOIN horses h
ON b.table1.stallid = h.dogs.dogid
SET b.table1.stallid = h.dogs.dogid
AND b.table1.incentid = '23'
WHERE h.dogs.bcb = 'BCB'

Error
> 1054 - Unknown column 'h.dogs.bcb' in 'where clause'

That column bcb is in the database and there are records in the dogs table where the column bcb = BCB

1/23/2023 5:14 pm | #2 Ray BorduinWebAssist

This was a minor syntax issue we worked through in a support ticket.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.