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