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