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 |
|
Sanatan
Starting Member
19 Posts |
 Posted - 2009-03-12 : 16:48:34
|
| Hi I need some help with the following SQL Query.OwnerTableMAPCOL OWNERCOLMap1 Owner1Map1 Owner2Map2 Owner1Map3 Owner2Map3 Owner3RelationTableKEYCOL MAPCOLKey1 Map1Key1 Map2Key2 Map2Key2 Map3Key3 Map3ProcessTable (KEYVAL+COLVAL forms a Primary key)KEYCOL VALCOLKey1 Val1Key1 Val2Key2 Val3Key3 Val3 Query Result should be retrived from the ProcessTable as belowFor Owner1----------Val1Val2For Owner2----------Val1val2Val3For Owner3----------Val3Please let me know if more clarification is needed of the table structure. Thanks in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Need help with the query...