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. Oh, in reality there are three more such
pairs (d1, d2, e1, e2, f1, f2), but the above should be sufficient to develop a
pattern. My current query
SELECT a1 AS foo
FROM t
WHERE a1 != '' AND a2 != '' AND a1 = a2
UNION ALL
SELECT b2 AS foo
FROM (
SELECT b1, b2
FROM t
WHERE a1 != '' OR a2 != '' OR a1 != a2
) tmp
WHERE tmp.b1 != '' AND tmp.b2 != AND tmp.b1 = tmp.b2
UNION ALL
and so on...
--
Puneet Kishor
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
