SELECT tbl_lab_setup_Test.[Test_Code], tbl_lab_setup_Test.Test_Name, [Sex_Description], [Age_Text], [Test_Reference_Text], [Unit_Title], [Test_Reference_Cri1], [Test_Reference_Cri2] FROM [LAB_DB].[dbo].[view_lab_setup_Test_Numeric_Reference] JOIN tbl_lab_setup_Test ON [view_lab_setup_Test_Numeric_Reference].Test_Code = tbl_lab_setup_Test.Test_Code WHERE Test_Reference_Id IS NOT NULL AND tbl_lab_setup_Test.Test_Inactive = '0' ORDER BY tbl_lab_setup_Test.Test_Code, Test_Reference_Id
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload 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