John <tauru...@gmail.com> wrote: > So now I know that case can return column names. But is there a way to tell > it from which table to select. > Earlier I assumed that it is not possible. But know I requestioning > everything. > This, at least, has not worked: > > create table t1 (col integer); > create table t2 (col integer); > > select * from > (select case > when 1=1 > then t1 > else t2 > end);
select * from t1 where 1=1 union all select * from t2 where not (1 = 1); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
