Hi,
I'm wondering if there is a syntax to do case insensitive join. Of
course, I could generate two new tables, with the both joining columns
converted to lower case (or upper case). But I'd like a simpler
solution.
#!/usr/bin/env bash
rm -f main.db
sqlite3 main.db <<EOF
create table A (a text, b integer, c integer);
create table B (a text, d integer, e integer);
insert into A values('a', 4, 7);
insert into A values('b', 5, 8);
insert into A values('c', 6, 9);
insert into B values('A', 4, 7);
insert into B values('B', 5, 8);
insert into B values('D', 6, 9);
.mode column
.headers on
.echo on
select * from A, B where A.a=B.a;
select * from A inner join B on A.a=B.a;
select * from A join B on A.a=B.a;
EOF
--
Regards,
Peng
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
