CREATE VIEW [dbo].[pal_vNoteDetail]
AS
SELECT	N.*
		,U.userDisplay addUser
		,U2.userDisplay editUser
FROM	pal_Note N
		JOIN pal_vUserShared U
			ON U.recId = N.userIdSaved		
		LEFT JOIN pal_vUserShared U2
			ON U2.recId = N.userIdUpdated
GO
