Pomogite plizzzzzzz....
Nugno sozdat' VIEW s UNION, toest' ob'edenit' dve ili bol'she tablits...
vot kod kotori' ne prorabotal na SYBASE, ORACLE...

CREATE VIEW CheckListVIEW
AS
SELECT
WorkItem.name,
WorkItem.actualActivation ,
WorkItem.actualCompletion ,
WorkItem.actualInitiation ,
WorkItem.dueDate ,
WorkItem.responseVar_oidval,

CheckList.defaultPartic_oidval

FROM WorkItem,CheckList
WHERE CheckList.oidval = WorkItem.activity_oidval

--=========================================================

CREATE VIEW PromptVIEW
AS
SELECT
WorkItem.name,
WorkItem.actualActivation ,
WorkItem.actualCompletion ,
WorkItem.actualInitiation ,
WorkItem.dueDate ,
WorkItem.responseVar_oidval,

Prompt.defaultPartic_oidval

FROM WorkItem,Prompt
WHERE Prompt.oidval = WorkItem.activity_oidval

--=========================================================

CREATE VIEW TootVIEW
AS
SELECT *
FROM CheckListVIEW
UNION
SELECT *
FROM PromptVIEW

--======================ERROR===================================
Execution Time 0.
SQL Server cpu time: 0 ms. SQL Server elapsed time: 0 ms.
Server Message: Number 197, Severity 15
Line 5:
Set operators may not appear within the definition of a view.