On 20 Jul 2011, at 7:23pm, Jonas Sandman wrote: > sqlite> select ifnull(nullif(s.value, r.value), r.value) as value FROM real r > LEFT OUTER JOIN shadow s ON s.id=r.id; > 1 > 22 > 3 > 4 > > Or am I misunderstanding?
That looks fine. And if he uses that SELECT to make a VIEW he can treat the results as if they're a TABLE, and create an INDEX on them or any of those other things. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
