lundi 20 avril 2015

Decrease of number results between 2 operations

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 !

Aucun commentaire:

Enregistrer un commentaire