Код:
CREATE VIEW SaleObjects AS/* Dish Part */
SELECT
MidServer,
Visit,
UNI AS "DishUNI",
0 AS "ChargeUNI",
OrderIdent,
SessionUNI,
0 AS "ObjKind",
MenuItems00.Code AS "Code",
MenuItems00.Name AS "Name",
MenuItems00.AltName AS "AltName",
MenuItems00.RightLvl AS "RightLvl",
dbo.propCategPath(MenuItems00.SIFR) AS "TypePath",
Status,
SalesTerms_StartSale,
SalesTerms_StopSale,
iTaxDishType,
Seat,
0 AS "ExcludeFromEarnings",
PrListSum AS "SourceSum",
PaySum,
Quantity,
GlobalIdent,
iCreator,
iAuthor,
iCreatorRole,
iAuthorRole
FROM SessionDishes
LEFT JOIN MenuItems MenuItems00
ON SessionDishes.Sifr = MenuItems00.Sifr
UNION
/* Disc Part */
SELECT
MidServer,
Visit,
0 AS "DishUNI",
UNI AS "ChargeUNI",
OrderIdent,
SessionUNI,
1 AS "ObjKind",
Discounts00.Code AS "Code",
Discounts00.Name AS "Name",
Discounts00.AltName AS "AltName",
Discounts00.RightLvl AS "RightLvl",
dbo.propTypesPath(DishDiscounts.Sifr) AS "TypePath",
Status,
SalesTerms_StartSale,
SalesTerms_StopSale,
iTaxDishType,
Seat,
ExcludeFromEarnings,
CalcAmount AS "SourceSum",
PaySum,
1 AS "Quantity",
GlobalIdent,
iCreator,
iAuthor,
iCreatorRole,
iAuthorRole
FROM DishDiscounts
LEFT JOIN Discounts Discounts00
ON DishDiscounts.Sifr = Discounts00.Sifr
WHERE DishDiscounts.IsCharge = 1