Help!

  • Thread starter Thread starter neka_budala
  • Start date Start date
N

neka_budala

Hi!

I need help!

I need to create query wich gives duplicated data from 4 tables.

Table names are: Loc1, Loc2, Loc3, Loc4.
Entities in all tables are the same: Date, Time, Type, Ser number, Reg
number, Alias.

The query must give table with all entities finding the duplicates of
"Ser number" and "Reg number"
or only one of them from all tables.

In the way that gives duplicates
when repeating in the only two tables or three tables not necessarily
both entities.


Sample:

Loc1
Date Time Type Ser number Reg number
01.02.09 12:30 Siemens 12345 2453245
25.08.09 18:03 Lexmark 26598 2453245

Loc2
Date Time Type Ser number Reg number
03.02.09 13:34 Epson 23456 2397868

Loc3
Date Time Type Ser number Reg number
12.09.09 06:26 Siemens 12345 4587621


Result from query
Date Time Type Ser number Reg number From wich location is data
01.02.09 12:30 Siemens 12345 2453245 Loc1
03.05.09 15:22 Siemens 12345 2453245 Loc4
12.09.09 06:26 Siemens 12345 4587621 Loc3
25.08.09 18:03 Lexmark 26598 2453245 Loc1


I know its stupid...but i need it in this way.
 
Back
Top