UFN_EVENT_GETONSALEINFOWITHEVENTS

        CREATE function dbo.UFN_EVENT_GETONSALEINFOWITHEVENTS()
        returns table
        as
        return
            select
                EVENT.ID as EVENTID,
                ONSALEDATETIME,
                SALESMETHOD.TYPECODE as SALESMETHODTYPECODE
            from dbo.EVENTSALESMETHOD
            inner join dbo.EVENT on EVENTSALESMETHOD.EVENTID = EVENT.ID
            inner join dbo.SALESMETHOD on EVENTSALESMETHOD.SALESMETHODID = SALESMETHOD.ID