USP_DATALIST_FACILITY

                create procedure dbo.USP_DATALIST_FACILITY
                as
                    set nocount on;

                    select
                        FACILITY.ID,
                        EVENTLOCATION.NAME as [EVENTLOCATIONNAME],
                        FACILITY.PRICE
                    from
                        dbo.FACILITY
                    inner join
                        dbo.EVENTLOCATION on EVENTLOCATION.ID = FACILITY.ID;

                    return 0;