CASE WHEN TB.SIGNDOCTOR IS NULL THEN '0' ELSE '1' END AS V_SEL
SELECT TA.*, CASE WHEN TB.DISEASEID IS NULL THEN '0' ELSE '1' END AS V_SEL FROM T_DISEASEDICT TA LEFT JOIN T_DISEASE_ADVICE TB ON TA.DISEASEID = TB.DISEASEID
SELECT TA.*, CASE WHEN TB.DISEASEID IS NULL THEN '0' ELSE '1' END AS V_SEL FROM T_DISEASEDICT TA LEFT JOIN T_DISEASE_ADVICE TB ON TA.DISEASEID = TB.DISEASEID