>
> This is different bug.
> It will give different valuta_id from ts and valuta tables.
>I was able only to write two different queries, one with where and one with left outer join and save them like view, which work great.
> Who is guilty, obviously me, who does not know new sql sysntax and can not read it from manual and help and thought view designer knows it better and will create me correct syntax. But it did not.
>Thanks in advance, Vladimir Zhuravlev
In addition to what Jim said, you should download my eView utility from the files section here. It allows editing of these more complex views, and makes maintaining them in code a snap.
Erik Moore
Clientelligence