V_MEMBERSHIPLEVEL

Fields

Field	Field Type	Null	Description
NAME	nvarchar(207)
ID	uniqueidentifier

Definition

Copy


                create view V_MEMBERSHIPLEVEL
        as
        select '<'+MEMBERSHIPPROGRAM.NAME+'> - <'+MEMBERSHIPLEVEL.NAME+'>' as NAME, MEMBERSHIPLEVEL.ID
        from dbo.MEMBERSHIPPROGRAM inner join dbo.MEMBERSHIPLEVEL on MEMBERSHIPPROGRAM.ID = MEMBERSHIPLEVEL.MEMBERSHIPPROGRAMID