>You are correct, no tables are being updated via these views.
>What's happening is the user is doing some data-entry on the last one that's created and I'm manualy updating a table based on what they do.
>A straight SQL that doesn't go into a view would be fine, but then of course I don't think you can't edit the data in a temporary cursor. I suppose I could create a temporary table, but the I/O on the hard drive would probably be just as bad if not worse as doing it this way.
>I really just don't want to be sludging along requerrying half a dozen views when I know that there has to be a way to do it with one statement.
>Unfortunatly my SQL isn't that strong to begin with and this has turned into a rather complicated mess. Grrrrrr........
When you have a complex query with lots of joins it is desirable to break it up into several statements like these for performance reasons.