Oops, Apologies to all I misled. Image cant do it - last time I tried, it barfed anyway. Is a nested select any different from a join? jp jp, standard sql-99 syntax supported by postgres,ms sqlserver, oracle, mysql can update when you access multipe tables. for example: UPDATE titles SET pub_date = 'date value' WHERE title_id IN (SELECT title_id FROM title_author WHERE auth_id IN (SELECT auth_id FROM authors WHERE auth_name = 'Author Name')) You find the auth_id by searching the authors table and for title_id for that auth_id you update the pub_date. duane > -----Original Message----- > From: [log in to unmask] > [mailto:[log in to unmask]] On Behalf Of john pitman > Sent: Sunday, October 17, 2004 3:12 PM > To: [log in to unmask] > Subject: RE: [HP3000-L] Query - multifind - update > > > No, you cant do an update in a join. Almost NO SQL offers > this capability, except years ago (15+) there was a third > part DB on MPE that did, forget its name.....was quite a good > piece of work for its time. > > jp > > -----Original Message----- > From: HP-3000 Systems Discussion > [mailto:[log in to unmask]] On Behalf Of > Alan Yeo > Sent: > Saturday, 16 October 2004 12:32 AM > To: [log in to unmask] > Subject: Re: [HP3000-L] Query - multifind - update > > In article <[log in to unmask]>, Kim Borgman > <[log in to unmask]> writes > >Did a query multifind search last nite, and wanted to update > one of the > >fields. > > > >The query update told me "record has not yet been found". > When I had > >obviously found 200+. > > > >Yes I did a join first, and I could report on the field/records. > > > >Any thoughts ? Yes I had opened the DB in mode1... > > > > > From memory I'm fairly certain you cant do an update in > query after a join, as after a join what you are working with > is an internal query table, rather than with pointers to the > actual records. > > However I suspect someone may prove me wrong :-) > > Alan > > -- > Alan Yeo > [log in to unmask] Just because you're paranoid > Phone +44 1684 291710 it doesn't mean someone isn't!. > Fax +44 1684 291712 > > * To join/leave the list, search archives, change list settings, * > * etc., please visit http://raven.utc.edu/archives/hp3000-l.html * > > * To join/leave the list, search archives, change list settings, * > * etc., please visit http://raven.utc.edu/archives/hp3000-l.html * > * To join/leave the list, search archives, change list settings, * * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *