SELECT DISTINCT t.*, tb.ACCUSED_NAME, tb.ACCUSED_WORK_PLACE, tb.QUESTION_TYPE_CODE, tb.SOURCE_CODE,tb.SOURCE_UNIT
FROM T_JCProposed t , T_JCBusiness tj, T_BASICINFO tb, T_JCParagraph h WHERE
t.JCBusiness_id=tj.ID and tj.BasicInfo_id= tb.ID and h.JCPROPOSED_ID=t.ID
FROM T_JCProposed t , T_JCBusiness tj, T_BASICINFO tb, T_JCParagraph h WHERE
t.JCBusiness_id=tj.ID and tj.BasicInfo_id= tb.ID and h.JCPROPOSED_ID=t.ID