hi... a question on how to do an update on a table that depends on 'left/right' joins with other tables...
i have the following select that works. select u1.urltype as type, p1.fileID as fileID, l1.process as process, l1.status as status from university_urlTBL as u1 right join parsefileTBL as p1 on u1.ID =p1.university_urlID join latestParseStatusTBL as l1 on p1.fileID = l1.itemID where u1.universityID='40'; i simply wnat to be able to update the latestParseStatusTBL based upon the joins between the tables... (something like...) update latestParseStatusTBL, university_urlTBL as u1 right join parsefileTBL as p1 on u1.ID =p1.university_urlID join latestParseStatusTBL as l1 on p1.fileID = l1.itemID where u1.universityID='40' set l1.process = '1', l1.status = '13'; i've tried a number of derivatives of this approach with no luck.. i'm missing something simple.. searching through mysql.com/google hasn't shed much light!! any ideas/comments/asssistance/thoughts/etc.. thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
