SELECT from two tables (not same number of fields)

E

Eric S.

Hi,

I have two tables that contains almost the same information. The only
difference is that one of the tables (Dagsrapporter) has about 400 more
records than the other. I want to pick out only the records that are not
present in the other table (Dagsrapporter_20050702).

I thought this would work:
SELECT Dagsrapporter.*
FROM Dagsrapporter, Dagsrapporter_20050702
WHERE Dagsrapporter.[Mätar Nr]<>Dagsrapporter_20050702.[Mätar Nr];

But it just loops forever with the same record.


Thank you in advance!

/Eric
 
A

Allen Browne

Use the unmatched query wizard to find the records in Dagsrapporter that are
not in the other table.
 
E

Eric S.

Thanx!

"Allen Browne" skrev:
Use the unmatched query wizard to find the records in Dagsrapporter that are
not in the other table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Eric S. said:
I have two tables that contains almost the same information. The only
difference is that one of the tables (Dagsrapporter) has about 400 more
records than the other. I want to pick out only the records that are not
present in the other table (Dagsrapporter_20050702).

I thought this would work:
SELECT Dagsrapporter.*
FROM Dagsrapporter, Dagsrapporter_20050702
WHERE Dagsrapporter.[Mätar Nr]<>Dagsrapporter_20050702.[Mätar Nr];

But it just loops forever with the same record.


Thank you in advance!

/Eric
Click to expand...
Click to expand...
 
Top