General information
Forum:
Microsoft SQL Server
Title:
Only return 1 row for join
Hi
I can't remember how to do this.
I have two tables with a join
Table Contact has multiple rows for each row in table Individual.
I only want to return the earliest row in table Contact for each row in Table Contact. Each row in table contact has a created date and they are joined on individual_ref
How do I do that ?
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only