This one works very nice ... Thanks / Jim

>Another one

SELECT DISTINCT mt.* FROM mytable mt ;
>	JOIN TempAcctList ON acct IN (acct1, acct2, acct3)
>

>>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