dbo.view_kurs_detail

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.view_kurs_detail as SELECT        dbo.dt_currencies.id, dbo.dt_currencies_header.no_skep, dbo.dt_currencies_header.startdate, dbo.dt_currencies_header.enddate, dbo.dt_currencies_master.currenciescode, dbo.dt_currencies.rate, 
                         dbo.dt_currencies.currenciesid, dbo.dt_currencies.headerid, users_1.username AS create_by, dbo.dt_currencies.createdate AS create_date, dbo.users.username AS update_by, 
                         dbo.dt_currencies.editdate AS update_date
FROM            dbo.dt_currencies LEFT OUTER JOIN
                         dbo.users ON dbo.dt_currencies.editby = dbo.users.id LEFT OUTER JOIN
                         dbo.users AS users_1 ON dbo.dt_currencies.createby = users_1.id LEFT OUTER JOIN
                         dbo.dt_currencies_master ON dbo.dt_currencies.currenciesid = dbo.dt_currencies_master.id LEFT OUTER JOIN
                         dbo.dt_currencies_header ON dbo.dt_currencies.headerid = dbo.dt_currencies_header.id
GO