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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-01 : 08:13:28
|
| vinay writes "1) Let us consider three tables in a Pathway databasePathway table has pathway ID, pathway name and other details.Interaction table has Protein1 and protein 2 names involved in interaction, and their respective sites involved in the interaction.Protein table has Protein name, its sequence and structural features.a) How to extract the pathway corresponding to an interaction?b) How to extract the sequence and structural features for the regions ofthe proteins involved in interaction?" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-10-01 : 09:28:28
|
quote:
Originally posted by AskSQLTeam
vinay writes "1) Let us consider three tables in a Pathway databasePathway table has pathway ID, pathway name and other details.Interaction table has Protein1 and protein 2 names involved in interaction, and their respective sites involved in the interaction.Protein table has Protein name, its sequence and structural features.a) How to extract the pathway corresponding to an interaction?b) How to extract the sequence and structural features for the regions ofthe proteins involved in interaction?"
What type of shoes do Aliens wear?How about some DDL, sample data and a shot at the code your trying to write?Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric! |
 |
|
|
Amethystium
Aged Yak Warrior
701 Posts |
Posted - 2003-10-01 : 10:57:15
|
Sounds like an exam question to me!  __________________Make love not war! |
|
|
|
|
|
|
searching tables with matching words