Posted by brendan on 10/13/47 11:23

Hi,
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 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?

[Back to original message]