USE [LABORATORY]
GO
/****** Object:  StoredProcedure [dbo].[Lab_GetSelectedMedtech]    Script Date: 10/29/2020 12:31:53 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Lab_GetSelectedMedtech]
@RequestNum as varchar(10)
AS


SELECT M.MedTechID , 
	isnull(M.LastName,'') + ', ' + isnull(M.FirstName,'') + ' ' + isnull(M.Middlename,'') as MedTech,
	M.License,
	Isnull(N.MedTechID,'') as PerformCode,
	isnull(N.LastName,'') + ', ' + isnull(N.FirstName,'') + ' ' + isnull(N.Middlename,'') as Performer,
	N.License as LicPerform,
	(Select Isnull(Department,'') from tblablogbook where Requestnum=@Requestnum) as Department
from tbLabLogBook L
	left outer join build_file..tbCoMedtech M
		On L.VerifyID = M.MedTechID
	left outer join build_file..tbCoMedtech N
		On L.MedTechID = N.MedTechID
where L.RequestNum = @RequestNum;