[Dano2]

Hi I am trying to write a SQL statement to compare 2 values in a mdb.
Here is the example of what I want to do:

The table is called: TFJ_Frequent_TRN

In the table there are 2 columns:

Column 1 called: MM_Number
The number I want to find in the column is '1M09962600'

Column 2 called: Request_Date
The date I want to find is '1/15/2004 which is the date that matches the MM in the other column 1

So basically there are lots of MM numbers in one column and lots of dates in another column in the same table that correspond to each other and I want to join or compare a date to a MM number or a MM number to a date.
Any help would be great...thanks Dano