Re: [SQL] create view error

2003-07-09 Thread mila boldareva
ter join lclass lc on (lc.lcid = l.lclass) instead of what you use: > select * from locos l > left outer join > (select * from lclass) lc on lc.lcid = l.lclass in this way you automatically avoid the error that you had! cheers, Mila ---(end of br

Re: [SQL] LEFT JOIN and missing values

2003-03-12 Thread mila
T3), then the resulting table is only 90 rows instead of 100, besides, the values are different from the "right" ones from "full" T2. The missing combinations seem to be random. How can that be if T1 contains all values that might be in T2.id2, T2.id1? and what