Basic Question
I'm programmatically open a dataset using this select statement
- SELECT SOD_TAG_DET.*, TAG_MSTR.TAG_NUM
FROM SOD_TAG_DET, TAG_MSTR
WHERE (SOD_TAG_DET.TAG_ID = TAG_MSTR.TAG_ID) AND
(SOD_TAG_DET.SODMstrID = 20)
ORDER BY TAG_MSTR.TAG_NUM
however when I do updates against the dataset it fails (because of the
multiple tables I'm assuming)
so...
id like to use this statement -
select *, (SELECT TAG_NUM FROM TAG_MSTR WHERE Tag_mstr.TAG_ID =
SOD_TAG_DET.Tag_id) AS TAG_NUM from SOD_TAG_DET WHERE SODMstrid = 20
but MySQL doesn't like this either
I'm working with a disconnected recordset so when I do a batch update I have
multiple updates to apply (and this method works fine in the SQL Server
system I converting) so whilst I could loop through all the records and
apply multiple update statements the batch update is cleaner
suggestions...
TIA
Phil
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
