นับRERUN

PHOTO EMBED

Wed Jan 11 2023 07:16:21 GMT+0000 (Coordinated Universal Time)

Saved by @HUMRARE7 #sql

select 
  tbl_lab_setup_Test.Test_Code
  ,tbl_lab_setup_Test.Test_Name
  ,count(tbl_lab_setup_Test.Test_Name) as Count
  from [tbl_lab_log_Staff_Action]
  join view_lab_information_Request on [tbl_lab_log_Staff_Action].LSA_LN = view_lab_information_Request.IREQ_LN
  join tbl_lab_setup_Test on [tbl_lab_log_Staff_Action].[LSA_TEST_CODE] = tbl_lab_setup_Test.Test_Code
  where [LSA_TYPE] = 'ResRerun'
content_copyCOPY