(this could be a potentially duplicate post -- I was sure I sent it out, but I
can't find it in the out box. So, here goes again)
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
My current query is very cumbersome. I am doing one query, then UNIONing it
with the results of second query from the complement of the first query then
UNIONing that with with results of the third query from the complement of the
first and the second query and so on.
--
Puneet Kishor
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
