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