Mapping of duplicate records in two table for different Correspondence values

[Nil_Aher]

I have two tables having same field SR number in both table. & I need to map the entry date from Table A to Table B using SR number field

TABLE A

SR NO ENTRY_DATE
1-69512548794 4/13/16 13:34


1-69512548794 4/13/16 13:40
1-69512548794 4/14/16 13:50
1-69512399960 4/14/16 13:50
1-69512399960 4/11/16 13:50
1-69512399960 4/11/16 13:55


TABLE B

SR NO
1-69512548794
1-69512548794
1-69512548794
1-69512548794
1-69512399960
1-69512399960
1-69512399960


& I need the output like below

OUTPUT TABLE

SR NO ENTRY_DATE
1-69512548794 4/13/16 13:34
1-69512548794 4/13/16 13:40
1-69512548794 4/14/16 13:50
1-69512548794
1-69512399960 4/14/16 13:50
1-69512399960 4/11/16 13:50
1-69512399960 4/11/16 13:55



Please suggest how to get unique output even there are unique records

[CJ_London]

you need a uniqueID for each table - otherwise how does access decide which entry date to use for each record?