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 |
|
Swati Jain
Posting Yak Master
139 Posts |
 Posted - 2006-08-01 : 03:35:23
|
| consider the following tables1)Facultymasterfacultyid2)Batchbatchidlecturefacultyidlabfacultyid3)batchlecturefacultyid4)FeedbackbatchidfacultyidAfter matching above facultyidfor batch1 lecturefacultyid,lab_f_id=>3,2for batch2 lecturefacultyid,lab_f_id=>2,4in Feedback onlyfeedback for lab_f_id=>2 of batch1therefore i should get output as-----------------------------batch lectureid Feedback------------------------------batch1 3 Nullbatch2 2 Null But i get the output batch1 3 Nullbatch2 2 Some FeedbackHow i can use composite key to identify the lab or lecture faculty in feedback table |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-01 : 06:04:59
|
| Just include both columns in the joinon a.col1 = b.col1and a.col2 = c.col2==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
How to use composite key in Sql query?