The Source Code - Multilevel Security for Relational Databases - page 183

UNION
SELECT d b o.[D2-s].n am e, d b o.[G etCLa b el](d b o.[D2-s].C Nam e)
CName, dbo.[D2-s].Department, dbo.[GetCLabel](dbo.
[D2-s].CDept) CDept, dbo.[D3-ts].Salary,
dbo .[GetCLabel](dbo.[D3-ts].CSalary)
CSalary, dbo.[GetCLabel]([dbo].
[GetTCLabel](4, dbo.[D2-s].CName, dbo.
[D2-s].CDept, dbo.[D3-ts].CSalary)) TC
FROM dbo.[D2-s] JOIN
dbo.[D3-ts] ON dbo.[D2-s].Name = dbo.
[D3-ts].Name
UNION
SELECT dbo.[D2-ts].name, dbo.[GetCLabel](dbo.[D2-ts].CName)
CName, dbo.[D2-ts].Department, dbo.[GetCLabel](dbo.
[D2-ts].C D ept) C D ept, d b o.[D3-u].Salar y,
dbo .[GetCLabel](dbo.[D3-u].CSalary)
CSalary, dbo.[GetCLabel]([dbo].
[GetTCLabel](4, dbo.[D2-ts].CName, dbo.
[D2-ts].CDept, dbo.[D3-u].CSalary)) TC
FROM dbo.[D2-ts] JOIN
dbo.[D3-u] ON dbo.[D2-ts].Name = dbo.
[D3-u].Name
UNION
SELECT dbo.[D2-ts].name, dbo.[GetCLabel](dbo.[D2-ts].CName)
CName, dbo.[D2-ts].Department, dbo.[GetCLabel](dbo.
[D2-ts].C D ept) C D ept, d b o.[D3-c].Salar y,
dbo .[GetCLabel](dbo.[D3-c].CSalary)
CSalary, dbo.[GetCLabel]([dbo].
[GetTCLabel](4, dbo.[D2-ts].CName, dbo.
[D2-ts].CDept, dbo.[D3-c].CSalary)) TC
FROM dbo.[D2-ts] JOIN
dbo.[D3-c] ON dbo.[D2-ts].Name = dbo.
[D3-c].Name
UNION
SELECT dbo.[D2-ts].name, dbo.[GetCLabel](dbo.[D2-ts].CName)
CName, dbo.[D2-ts].Department, dbo.[GetCLabel](dbo.
[D2-ts].CDept) CDept, dbo.[D3-s].Salary,
dbo .[GetCLabel](dbo.[D3-s].CSalary) CSalary,
dbo.[GetCLabel]([dbo].[GetTCLabel](4, dbo.
[D2-ts].CName, dbo.[D2-ts].CDept, dbo.
[D3-s].CSalary)) TC
FROM dbo.[D2-ts] JOIN
dbo.[D3-s] ON dbo.[D2-ts].Name = dbo.
[D3-s].Name