SELECT CASE WHEN 0 = 0 AND (pfor_method IS NULL) AND [prev_RequireLogin] = 1 THEN 'http://www.atsmedia.com/scripts/cat_Previews.asp?igrp_ID=800' WHEN pfor_method = 'embed' THEN 'http://www.atsmedia.com/scripts/cat_Previews.asp?igrp_ID=800' ELSE (CASE WHEN prev_URL IS NOT NULL THEN prev_URL ELSE [pfor_URL] + [prev_FileName] + [pfor_FileExtension] END) END AS Preview_File_URL, CASE WHEN 0 = 0 AND [prev_RequireLogin] = 1 THEN 'yes' ELSE '' END AS SHOW_Login, CASE WHEN pfor_method = 'embed' THEN CAST(prevXpfor_ID AS varchar) ELSE CAST('' AS varchar) END AS prevXpfor_ID_DERIVED, CASE WHEN prevXpfor_ID = 0 THEN 'yes' ELSE '' END AS SHOW_current, *, pfor_ID AS SectionTitle FROM tblPreviewFormats INNER JOIN tbl_PreviewsXPreviewFormats ON tblPreviewFormats.pfor_ID = tbl_PreviewsXPreviewFormats.prevXpfor_pfor_ID RIGHT OUTER JOIN tblPreviews ON tbl_PreviewsXPreviewFormats.prevXpfor_prev_ID = tblPreviews.prev_ID WHERE prev_igrp_ID = 800 ORDER BY prev_Order, pfor_Order
ATSMedia Workplace Training Videos: Harassment, Diversity, Customer Service...

Newsletter