Tally.NET wrote:
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.


The most important thing you can do is to make sure that you
have an index on the fields using in the ON clause. You do
that in the tables' design view by using the View - Indexes
menu item.

--
Marsh
MVP [MS Access]