[RBASE-L] - Re: Finding unused id codes

[Bill Downall]

On Tue, 09 Sep 2003 09:39:42 -0500, Bill Downall wrote:

>SELECT codecolumn +
>  FROM lookuptable t1 +
>  WHERE NOT EXIST +
>(SELECT codeslistcolumn FROM datatable d2 +
>  WHERE d2.codeslistcolumn CONTAINS t1.codecolumn)

It does work, in my little test:

R>load tempcodes
 Begin R:BASE Data Loading for tempcodes
L>AA
L>AB
L>AC
L>AD
L>AE
L>AF
L>AG
L>end
 End R:BASE Data Loading
R>create table tempData (TempData text (20))
R>load tempdata
 Begin R:BASE Data Loading for tempdata
L>'AA,AC,AE,AG'
L>end
 End R:BASE Data Loading
R>sel * from tempcodes t1 where not exist (select * from tempdata d2 +
  where d2.tempdata contains t1.tempcode)
 tempcode
 --------
 AB
 AD
 AF
R>