sql question

[latinstorm]

Don't look unless know sql, it's not pretty.



I'm after the first 3 rows.

sqlite> .schema tree
CREATE TABLE tree (
parentid TEXT,
fileid TEXT NOT NULL,
name TEXT NOT NULL,
size INTEGER NOT NULL
);
sqlite> select * from tree l left join tree r on l.parentid = r.fileid where l.fileid='f6453';
0c894|f6453|test_files/|65||||
9fd1c|f6453|test/|65||||
9fd1c|f6453|test_files/|65||||
b5f20|f6453|test_files/|65|03314|b5f20|src/|29648923
03314|f6453|test/|65|00000|03314|share/|31826134
03314|f6453|test_files/|65|00000|03314|share/|31826134
sqlite> select * from tree l left join tree r on l.parentid = r.fileid where l.fileid='f6453' AND r.fileid=null;
sqlite>