Limit Number of records in a join

[Pipe2Path]

Here's my situation:

TableA --> TableB - 1-Many relationship

for the following query:

select * from tableA inner join TableB
on tableA.ID = TableB.ID

and my result brings back 2 records in TableB that match 1
record in TableA, how do I limit the query to output only 1 record from TableB?

e.g. ID nAME
1 John Smith
1 John Adams

So, I only want the first record from TableB to show up.

Thanks.

 

[Zathras]

I'm not sure you can do that exactly, but you can do this:

SELECT TableA.ID, Max(nAME)
FROM...
GROUP BY TableA.ID

That will bring back only one name per ID, but it may not be the one you want.

 

[Pipe2Path]

Thank you, I will try it. Looks promising.