>I have two tables as follows:
>

>callreport.dbf
>callrepid   actionid1  actionid2 ...  actionid10 ....
>
>
>actions.dbf
>actionid    action
>

>
>I need an sql statement that will produce a cursor containing only the callrepids from callreport.dbf that have an actionid (1-10) that is in the actions dbf.
>
>Hope this makes sense.
>
>Thanks in advance for your help!

Russell,

A normalized table would completely remove this problem.

One good piece of advice I learned years ago was: "When you start creating fields with numbers to show their order, you're making a mistake."