//表t_clm_case下claim_no列,与表t_clm_object下seq_no列用 - 结合
select TC.CLAIM_NO || '-' || TOB.SEQ_NO claimno from t_clm_case tc left join t_clm_object tob on tc.case_id = tob.case_id
[img]http://dl2.iteye.com/upload/attachment/0119/4075/0f335ef1-9f9d-34e7-a205-e023bc1979ce.png[/img]