Hi Garry,
As far as i understand you need to update two tables at the same time, but
instead you are doing the other way around i guess? You are first inserting
into one table, then retrieving from that table to update the tblStock, why
not update them at the same time, in the same code?
LOCK TAB
On Sun, 2003-02-16 at 16:38, Arda Balci wrote:
> Hi Garry,
>
> Check INSERT ... SELECT syntax from the manual,
> here is the example from there:
>
> INSERT INTO tblTemp2 (fldID) SELECT tblTemp1.fldOrder_ID FROM tblTemp1 WHERE
> tblTemp1.fldOrder_ID > 100;
>
> If the source values are to be proce
the mysql functions in your query.
arda
- Original Message -
From: "garry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 16, 2003 5:49 PM
Subject: joining queries
> I would like to use values in one table to update those in another but i
>
I would like to use values in one table to update those in another but i
only want to use one query. Is there any way to do this.
regards
garry saddington
-
Before posting, please check:
http://www.mysql.com/manual.php (th
