Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Getting just one row from a set of many possible rows.
The simplified scenario is something like this: There is a client table with the client details. Each client is associated with a marketing group which may have one or more relationship managers. I needed (previously, the situation is more complicated now)just one (any one) of the relationship...- rhtiwari
- Post #3
- Forum: Sybase: Adaptive (SQL) Server
-
Getting just one row from a set of many possible rows.
I am doing a join across three tables and the third table has multiple rows for the field on which it is joined. I need just one (any one is fine) of the rows. Is it somehow possible to do it? Thanks!- rhtiwari
- Thread
- Replies: 3
- Forum: Sybase: Adaptive (SQL) Server
