All pastes #343128 Raw Edit

Stuff

public sql v1 · immutable
·published 2007-02-06 20:16 UTC
rendered paste body
sqlite> SELECT * from lista;id	nazwa1	Myk Myk2	Pyk Pyk3	Brum Brum4	Cokolwiek5	Kojojowe jarmarkisqlite> SELECT * from exclude;id	lista_id1	42	5sqlite> SELECT * FROM lista, exclude where lista.id!=exclude.lista_id;id	nazwa	id	lista_id1	Myk Myk	1	41	Myk Myk	2	52	Pyk Pyk	1	42	Pyk Pyk	2	53	Brum Brum	1	43	Brum Brum	2	54	Cokolwiek	2	55	Kojojowe jarmarki	1	4sqlite> SELECT * FROM lista where id!=(SELECT lista_id FROM exclude);id	nazwa1	Myk Myk2	Pyk Pyk3	Brum Brum5	Kojojowe jarmarkisqlite>