Phil009, thanks, but of course my table is not only with values A, B, etc...
This was an example to illustrate what kind of job I want to perform.
One table has actually 2k records and the other 300
I want to have a new table with all record in table 1 that are not in table 2.
Get it?
Thanks
Hi,
I don't know how to create a simple query that will compare 2 tables and create a new one after that.
Each table has only one field.
Example:
Table 1 has records A, B, C, D and E
Table 2 has records A and C
I want new table to be like table 1 minus table 2. Like cleaning up table 1.
New...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.