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 *are* allowed to use JOINED
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.
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
realised with this version of mysql and I am
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
realised with this version of mysql and I am
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 *are* allowed to use JOINED
Multi Table UPDATES are first supported in 4.0.x
-Original Message-
From: Brendan Gogarty [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 09, 2005 12:16 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: JOIN QUERY - UPDATE ... help?!
Brendan Gogarty [EMAIL PROTECTED