SELECT case_no from table_a ta 
  WHERE EXIST (select case_no from table_b tb  WHERE tb.case_no = ta.case_no) 
  into cursor dup_record

>
>I think I have read this before & I forget it completely...
>
>For instance, case_no in 2 tables may be duplicated, I want to find which number is duplicated, how can I do this in SQL command?
>
>I think it is something like this:
>
>[CODE]
>SELECT case_no from table_a IN EXIST (select case_no from table_b) into cursor dup_record
>[/CODE]