USE [AJK]
GO

/****** Object:  View [dbo].[view_user_group_menu]    Script Date: 13/09/2018 18:48:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE VIEW [dbo].[view_user_group_menu]
AS
	SELECT us.user_group_menu_id
      ,us.group_menu_id
	  ,s.[description]
      ,us.username
      ,us.created_by
      ,us.created_date
      ,us.is_active
	  FROM [dbo].[custport_m_user_group_menu] us
	  INNER JOIN [dbo].[custport_m_group_menu] s ON us.group_menu_id=s.group_menu_id
	  WHERE us.is_active=1
  




GO


