I'm facing a strange SQL problem, I have there 2 requests:
INSERT INTO tmp_copy SELECT champs FROM tmp WHERE champs IN (SELECT champs FROM myTable) COPY (SELECT * FROM myTable WHERE champs IN (SELECT champs FROM tmp_copy)) TO 'bla/bla.csv' WITH DELIMITER ';';
This operation is as simple as it looks like.
The first request put in the table "tmp_copy" the common lines between tmp and myTable, and the second request put in a file the inverse operation.
But in the process, I lost a lot of results and I don't know why. For me the number result should be the same...
Thanks for help !