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 *
|