Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Only return 1 row for join
Message
 
To
16/01/2013 08:08:42
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01562935
Message ID:
01562938
Views:
35
>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

Some example data and desired result from it?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform