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
