Skip to Content
0
Former Member
Feb 26, 2009 at 09:35 PM

Join two tables, return max 1 record for each left

46 Views

I want to join tables A and B, but I only want to return a maximum of one record for each record on the left. For example

Table A

Bob,1

John,2

Jill,3

Table B

1,MountainTime

1,MountainTime

2,CentralTime

3,PacificTime

Result

Bob,MountainTime

John,CentralTime

Jill,PacificTime