Assuming that SerialAndDate is a combination of the fields Serial and Date, I
would use a query like the following and ignore the SerialAndDate field.

SELECT Table1.Serial, Table1.Item, Table1.Date
FROM Table1 INNER JOIN Table2
ON Table1.Serial = Table2.Serial
AND Table1.Date = Table2.Date

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Tally.NET wrote:
Hello,

I have the following Input tables

Table1
Serial Item Date SerialandDate
123 Item1 01-04-2007 12339173
123 Item2 01-06-2010 12340330
234 Item1 01-10-2006 23438991
234 Item3 02-04-2010 23440270
234 Item2 01-01-2009 23439814


Table2
Serial Date SerialandDate
123 01-06-2010 12340330
234 02-04-2010 23440270


and i am looking at an Output as below

Serial Item BillDate
123 Item2 01-06-2010
234 Item3 02-04-2010



I am trying this SQL (MS Access 2003) however the query is taking too long to process and the system does not respond.

SELECT Table2.[Serial], Table2.[BillDate], Table1.Item
FROM Table1 INNER JOIN Table2 ON Table1.SerialandDate = Table2.SerialandDate;

There are about 25000 records in both the tables.


ITCat