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 |
|
baze7
Yak Posting Veteran
58 Posts |
 Posted - 2011-01-31 : 11:13:18
|
| This will return multiple spc.notescontent, how can I combine to a single return? Example it will returnnotes1notes2and I want notes1 notes2SELECT spc.NoteContent FROM ObjectNotes obn INNER JOIN NoteHeaders nth ON nth.NoteHeaderToken = obn.NoteHeaderToken LEFT OUTER JOIN SpecificNotes spc ON spc.SpecificNoteToken = obn.SpecificNoteToken where obn.RefRowPointer = 'E4A0AF28'Thanks! |
|
|
nathans
Aged Yak Warrior
938 Posts |
|
|
|
|
|
Combine returns