At 09:46 AM 11/20/97 -0500, you wrote:
> Couldn't you create a view joining the two tables together (if like
> fields exist??) and then execute an update statement? Perhaps it is
> worth trying.


Would that it were true. But again, maybe not. The SQL Reference manual has the rules for what makes a view read-only:

Read-only views: A view is read-only if any of the following appear in its
- The first FROM clause identifies more than one table or view.
- The first FROM clause identifies a read-only view.
- The first SELECT clause specifies the keyword DISTINCT.
- The outer subselect contains a GROUP BY clause.
- The outer subselect contains a HAVING clause.
- The first SELECT clause contains a column function.
- The subselect contains a subquery such that the base object of the outer
subselect, and of the subquery, is the same table.


Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480

+--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to "". | To unsubscribe from this list send email to | Questions should be directed to the list owner/operator: +---

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].