>>It's legal to use UNIONs in a view, as long as it's defined with CREATE SQL VIEW and you don't later attempt to modify it with the VFP View Designer.
>>
>>However...
>>
>>Is it good practice to use UNION clause(s) in a view? Or, is that usually a sign that the database should be refactored?
>
>I think using UNION may be a (good) sign that the database is successuflly normalized. Usually views are used to denormalize data for particular uses, such as querying or reporting.

Since a cursor from a UNION query will not be updateable, is there any reason to use a view rather than just a cursor? Might it add unnecessary overhead?