SELECT TUP_TAG_NO AS TAG, ( CASE ( CASE (SELECT ttt_prnt_tag_no FROM INTTTT_REC WHERE ttt_itm_ctl_no = tup_itm_ctl_no) WHEN NULL THEN (SELECT MIN(pkc_cmpt_tag_no) FROM INTPKC_REC WHERE pkc_pkg_ctl_no = tup_itm_ctl_no GROUP BY pkc_pkg_ctl_no) ELSE (SELECT ttt_prnt_tag_no FROM INTTTT_REC WHERE ttt_itm_ctl_no = tup_itm_ctl_no) END ) WHEN NULL THEN (SELECT TRIM(tag_mst_tag_no) FROM INTTAG_REC WHERE tag_itm_ctl_no = tup_itm_ctl_no) ELSE ( CASE ( SELECT tag_mst_tag_no FROM INTTAG_REC WHERE tag_itm_ctl_no = ( CASE (SELECT ttt_itm_ctl_no FROM INTTTT_REC WHERE ttt_itm_ctl_no = tup_itm_ctl_no) WHEN NULL THEN (SELECT MIN(pkc_cmpt_ctl_no) FROM INTPKC_REC WHERE pkc_pkg_ctl_no = tup_itm_ctl_no GROUP BY pkc_pkg_ctl_no) ELSE (SELECT ttt_itm_ctl_no FROM INTTTT_REC WHERE ttt_itm_ctl_no = tup_itm_ctl_no) END ) ) WHEN NULL THEN (SELECT TRIM(atg_mst_tag_no) FROM INAATG_REC WHERE atg_itm_ctl_no = ( CASE (SELECT ttt_itm_ctl_no FROM INTTTT_REC WHERE ttt_itm_ctl_no = tup_itm_ctl_no) WHEN NULL THEN (SELECT MIN(pkc_cmpt_ctl_no) FROM INTPKC_REC WHERE pkc_pkg_ctl_no = tup_itm_ctl_no GROUP BY pkc_pkg_ctl_no) ELSE (SELECT ttt_itm_ctl_no FROM INTTTT_REC WHERE ttt_itm_ctl_no = tup_itm_ctl_no) END ) ) ELSE ( SELECT TRIM(tag_mst_tag_no) FROM INTTAG_REC WHERE tag_itm_ctl_no = ( CASE (SELECT ttt_itm_ctl_no FROM INTTTT_REC WHERE ttt_itm_ctl_no = tup_itm_ctl_no) WHEN NULL THEN (SELECT MIN(pkc_cmpt_ctl_no) FROM INTPKC_REC WHERE pkc_pkg_ctl_no = tup_itm_ctl_no GROUP BY pkc_pkg_ctl_no) ELSE (SELECT ttt_itm_ctl_no FROM INTTTT_REC WHERE ttt_itm_ctl_no = tup_itm_ctl_no) END ) ) END ) END ) AS MASTER_TAG, FROM TRJTUP_REC, TRJTUD_REC, TRJTPH_REC, INRFSH_REC, ARRCUS_REC, TCTNAD_REC WHERE `MASTER` = '123456'
SELECT (100 - YearsOld) AS YearsRemaining FROM People WHERE (100 - YearsOld) > 0
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)