a2 != '' seems redundant when a1 = a2 and a1 != ''
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 20 Feb 2012, at 1:37am, Puneet Kishor 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
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
3 matches
Mail list logo