>>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?
If it's not broken, fix it until it is.
My Blog