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 |
|
sona
Yak Posting Veteran
68 Posts |
 Posted - 2001-12-11 : 05:56:15
|
| i have 3 tablesGrouptable: GroupID(IDENTITY) , Groupname classTable: ClassId(IDENTITY) ,GroupID,ClassnameFilterTable:FilterID(IDENTITY) ,ClassID,FilternameI want the output asgroupname,classname,filtername (ALL related ones on ID ) in a single query. |
|
|
LarsG
Constraint Violating Yak Guru
284 Posts |
Posted - 2001-12-11 : 07:24:45
|
| select Groupname,Classname,Filtername from grouptable as g join classtable as c on g.GroupID = c.GroupID join filtertable as f on c.ClassID = f.ClassID |
 |
|
|
|
|
|
Selection