repo.or.cz
/
csql.git
/
blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
history
|
raw
|
HEAD
code reorg
[csql.git]
/
test
/
sql
/
OuterJoin
/
simpleleft.sql
blob
51995769e6832327d722a822fc641077e1733a17
1
CREATE TABLE t1 (f1 INT , f2 INT , primary key(f1));
2
CREATE TABLE t2 (f1 INT , f2 INT , primary key(f1));
3
INSERT INTO t1 VALUES(1,1);
4
INSERT INTO t1 VALUES(2,2);
5
INSERT INTO t2 VALUES(1,1);
6
select * from t1 left join t2 on t1.f1=t2.f1;