Convert Snippet to Image

Preview:

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'

Download PNG Download JPEG Download SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter