>>>>>>I already re-wrote it correctly for you. Why did you write it incorrectly again?
>>>>>
>>>>>Cause i had it before an when i used one "ON" it keeps tellin me not a character expression
>>>>
>>>>Ok, fix the query first the way I wrote it.
>>>
>>>ok i got this...exactly
>>>
>>>SELECT Otest.app,Otest.id,Otest,fname,Otest.bday,;
>>>dup.numrec;
>>>FROM;
>>> mainbase!otest;
>>>INNER JOIN (select fname as FName, COUNT(*) as numrec FROM otest group by FName HAVING COUNT (*)>1) ;
>>>dup on otest.fname=dup.fname
>>>
>>
>>Right and this query should work.
>
>
>sigh...it so doesnt,
>Not a character expression error, and fname is a character
>
>it points to the join
>is this a good time 2 tell you i set engine behavior to 70 for a different query to work?
I see a typo here
Otest,fname && should be dot, not comma.
I would stay away from behavior 70 and better fix the queries.
If it's not broken, fix it until it is.
My Blog