To preserve records.

[Guest]

Hi!

I have ten big tables each with 5.000 records.
Some only records has data in fields.
But I have a list with about 400 not consecutive numbers of the records ID
to preserve.

If is possible:
1 - I would like to know what is the syntax, only based in ID number, to
delete not listed records; or
2 - I would like to know what is the syntax, only based in ID number, to
append listed records.

Thanks in advance.
an

 

[Marshall Barton]

I have ten big tables each with 5.000 records.
Some only records has data in fields.
But I have a list with about 400 not consecutive numbers of the records ID
to preserve.

If is possible:
1 - I would like to know what is the syntax, only based in ID number, to
delete not listed records; or
2 - I would like to know what is the syntax, only based in ID number, to
append listed records.

Use a query that joins the two tables.

SELECT table.*
FROM table LEFT JOIN preserve
ON table.ID = preserve.ID
WHERE preserve.ID Is Null

will find records in table that are missing in preserve.

SELECT table.*
FROM table INNER JOIN preserve
ON table.ID = preserve.ID

will find records that are in both.

FYI, I think a table with 5,000 records is a small table.
Big tables have a few hundred thousand records and huge
tables are in the million+ range.

 

[Guest]

Ok, MB

Thank you very much.
an

Use a query that joins the two tables.

SELECT table.*
FROM table LEFT JOIN preserve
ON table.ID = preserve.ID
WHERE preserve.ID Is Null

will find records in table that are missing in preserve.

SELECT table.*
FROM table INNER JOIN preserve
ON table.ID = preserve.ID

will find records that are in both.

FYI, I think a table with 5,000 records is a small table.
Big tables have a few hundred thousand records and huge
tables are in the million+ range.