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 |
|
sqldba2k6
Posting Yak Master
176 Posts |
 Posted - 2006-07-13 : 14:04:43
|
| I need help in writing the query to get the output.Table:SINSID SEID FMID TP--- ---- --- ---126 4000 5107 A115 NULL 5107 B116 NULL 5107 BTable:HITRNRSNP SID ------ ---- NULL 121NULL 131NULL 11308 11609 103NULL 128NULL 119NULL 107NULL 110Now i want the output like below.RNRSNP SID SEID ------ ---- ----- 08 116 4000Thanks for help in advance! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Query Issue