Hi,
We are running mysql 3.23.58 and I want to do a query with joins
from two tables and then insert the
results into the column of a third. This appears to be harder than I
realised with this version of mysql and I am banging my head against a
wall. Please Help!
ok first query.
-----------------------------------------------------
"select link_ID,of_group
FROM
page_elements
LEFT JOIN pages
ON page_elements.link_to=pages.page_ID
LEFT JOIN links_DB_bk
ON page_elements.link_ID=links_DB_bk.link_ID
WHERE content_type='text'"
-----------------------------------------------------
Now I want to update table 3 (links_DB) using
page_elements.link_ID=links_DB.link_ID
usual update query doesn't seem to work in this circumstance
..
any ideas?
