>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!
SELECT CR.* FROM callreport CR ;
JOIN actions A ON A.actionid IN (CR.actionid1,CR.actionid2 ... ,CR.actionid10 ....)