Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jimmyb1651
Starting Member
5 Posts |
 Posted - 2001-04-01 : 18:43:16
|
| While looking for help with another topic, I ran across an article on a new SQL Server 2000 feature that would return a recordset column as a recordset itself. For instance, if I wanted to show a list of teachers and their courses the query would return a record for each teacher with a courses column that contains a recordset of the courses taught by that teacher. Does anyone know the SQL that does this? |
|
|
|
|
|
Alternative to INNER JOIN