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 |
|
bgawde
Starting Member
1 Post |
 Posted - 2003-07-30 : 10:38:35
|
| Clients-------------------------CID (PK)ClientNameStaff----------------------------SID (PK)StaffNameClientStaff-----------------------------SID (FK, PK)CID (FK, PK) for each client there may be 3 staff associated......So I want to write a query which will return me results likeClientName1 StaffName1 StaffName2 staffname3ClientName2 StaffName1 StaffName2 staffname3ClientName3 StaffName5 StaffName6 staffname3ClientName4 StaffName10 StaffName22 staffname33Thanks |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-07-30 : 11:01:13
|
| Take a lookhttp://www.sqlteam.com/SearchResults.asp?SearchTerms=cross |
 |
|
|
|
|
|
Sql Help