USP_DATALIST_NAMINGOPPORTUNITYFACILITY

                create procedure dbo.USP_DATALIST_NAMINGOPPORTUNITYFACILITY
                as
                    set nocount on;

                    select
                        NAMINGOPPORTUNITYFACILITY.ID,
                        NAMINGOPPORTUNITYFACILITY.NAME,                        
                        NAMINGOPPORTUNITYFACILITY.ADDRESSBLOCK as ADDRESS,
                        NAMINGOPPORTUNITYFACILITY.CITY,
                        (select STATE.ABBREVIATION from dbo.STATE where STATE.ID = NAMINGOPPORTUNITYFACILITY.STATEID),
                        NAMINGOPPORTUNITYFACILITY.POSTCODE,
                        (select DESCRIPTION from dbo.NAMINGOPPORTUNITYAREACODE where NAMINGOPPORTUNITYAREACODE.ID = NAMINGOPPORTUNITYFACILITY.AREACODEID) as AREA,
                        (select DESCRIPTION from dbo.NAMINGOPPORTUNITYUNITCODE where NAMINGOPPORTUNITYUNITCODE.ID = NAMINGOPPORTUNITYFACILITY.UNITCODEID) as UNIT
                    from
                        dbo.NAMINGOPPORTUNITYFACILITY
                    order by
                        NAMINGOPPORTUNITYFACILITY.NAME;