Hello!
I making database in ACCESS 2003, and I have problem with make query.
There is a two tables with no relationships. I want to make query which give me only records which is not in two tables at the same time.
Example .
Table 1.
1
2
3
4
Table 2
1
2
Query must Show me 3 and 4 from first table (it`s not in second table).
I have access 2003 bible but i dont know how to start with this query. I tried a lot of my ideas with no results. Query show me only all records or oly this which are on two tables at the same time.
Regards Lukas
Sory for my english.