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
Jim Nelson
Newbury Park, CA