repo.or.cz
/
sqlgg.git
/
blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
history
|
raw
|
HEAD
opam: update
[sqlgg.git]
/
test
/
database.sql
blob
7e786dff0084f3da1c1a8ccaf95285ed2b25d1e4
1
CREATE TABLE database1.test (id INT PRIMARY KEY, txt TEXT);
2
CREATE TABLE database2.test (id INT PRIMARY KEY, amount INT);
3
4
SELECT COUNT(*)
5
FROM database1.test t1
6
FULL OUTER JOIN database2.test t2 ON t1.id = t2.id
7
WHERE t1.id IS NULL OR t2.id IS NULL;