Puneet Kishor <punk.k...@gmail.com> wrote: > Say I have table like so > > CREATE TABLE t ( > a1, a2, > b1, b2, > c1, c2 > ); > > I want > > a1 AS foo WHERE a1 != '' AND a2 != '' AND a1 = a2 > > from the remaining > > b1 AS foo WHERE b1 != '' AND b2 != '' AND b1 = b2 > > from the remaining > > c1 AS foo WHERE c1 != '' AND c2 != '' AND c1 = c2 > > from the remaining > > 'none' AS foo > > Right now I am doing a bunch of UNION ALLs of separate queries, but am > wondering if there is a better way.
select (case when a1 != '' AND a2 != '' AND a1 = a2 then a1 when b1 != '' AND b2 != '' AND b1 = b2 then b1 when c1 != '' AND c2 != '' AND c1 = c2 then c1 else 'none' end) as foo from t; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users