SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE view [dbo].[vw_acc_profits_losses]
as
	select	a.*, pl.*
	from	acc_accounts a
			left join acc_profits_losses pl on pl.apl_pr_loss_id = a.a_account_id
	where	a.a_type_code = 'PL'



GO
