>>>Otest,fname && should be dot, not comma.
>>>
>>>I would stay away from behavior 70 and better fix the queries.
>>
>>yea i set the behaviors to 90 an 80 same but i change a line last line
>>

>>dup on otest.fname=dup.fname
>>&&TO
>>dup on otest.id=dup.id
>>

>>
>>and it said column ID couldnt be found an i do hav an id or do i have to modify the whole select
>
>I definitely have some ideas, but perhaps it's time for you to try to think a bit on your own?

ive been thinkin since i starting this topic 2 days ago. I like queries but this one is extremely troublesome