I have an old DBF that I'm accessing that has account numbers stored in 9 fields, "ACCT1", "ACCT2", etc.

I need to select all records where any of these accounts appear in a list of accounts which is in a cursor ("TempAcctList") with one field.

Is there any simpler way to select these records than the following:

SELECT * From OldTable ;
where acct1 in (select * from TempAcctList) ;
or acct2 in (select * from TempAcctList) ;
or acct3 in (select * from TempAcctList) ;
... etc, through all nine accounts

I can certainly do this, but am just wondering if there's any simpler construction, or more efficient way to do this.

Thanks in advance