I guess I can't do like thisSELECT id,a,b FROM T WHERE id NOT IN (SELECT id FROM T2 WHEREc=5) LIMIT 20;
I only want 20 rows.How do I do it?
I have tableT (id ,a,b integer, primary key(id) );T2 (id