JOIN QUERY -> UPDATE ... help?!

2005-08-09 Thread Brendan Gogarty
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. --

RE: JOIN QUERY -> UPDATE ... help?!

2005-08-09 Thread Brendan Gogarty
"Brendan Gogarty" <[EMAIL PROTECTED]> wrote on 08/09/2005 05:30:51 AM: > 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 > real

RE: JOIN QUERY -> UPDATE ... help?!

2005-08-10 Thread Brendan Gogarty
Brendan Gogarty wrote: > 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. [snip] Shawn Green wrote: > Start from here: > http://dev.mysql.com/doc/mysql/en/update.html > > Updates *a