Dominic85 Posted April 10, 2006 Share Posted April 10, 2006 first thing is how to search the keywords from the tablesSecond thing after u search the result ,how to link the result to a number related to the result? Link to comment Share on other sites More sharing options...
Dominic85 Posted April 10, 2006 Author Share Posted April 10, 2006 hey can someone pls help mi? Link to comment Share on other sites More sharing options...
Dominic85 Posted April 10, 2006 Author Share Posted April 10, 2006 something like that? SELECT Omim_NoFROM avWHERE Description LIKE '%LIVER%'ORDER BY Omim_No ASCSELECT Omim_NoFROM csWHERE CS_Description LIKE '%LIVER%'OR CS_DATA LIKE '%LIVER%'ORDER BY Omim_No ASCSELECT Omim_NoFROM tiWHERE Omim_Titles LIKE '%LIVER%'ORDER BY Omim_No ASCSELECT Omim_NoFROM ti_alt_titleWHERE Omim_Alt_Titles LIKE '%LIVER%'ORDER BY Omim_No ASCSELECT Omim_NoFROM txWHERE Omim_Text LIKE '%LIVER%'SELECT subsnp_id,pop_id,allele_idFROM AlleleFreqBySsPopWHERE source LIKE '%LIVER%'i want to search for the keywords, and display the result as in Omim_No and link the Omim_No to a table contain Omim number.. i got multiple tables.. some tables contain only number without words.. Link to comment Share on other sites More sharing options...
Dominic85 Posted April 10, 2006 Author Share Posted April 10, 2006 oh.. come on.. pls help mi.. Link to comment Share on other sites More sharing options...
aspnetguy Posted April 10, 2006 Share Posted April 10, 2006 your questions are very vague. Where is omim number?? What do you mean link to another table.What do you want to do (specificly) with the data returned from your select statement??? Link to comment Share on other sites More sharing options...
Dominic85 Posted April 11, 2006 Author Share Posted April 11, 2006 your questions are very vague. Where is omim number?? What do you mean link to another table.What do you want to do (specificly) with the data returned from your select statement???<{POST_SNAPBACK}> now i got multiple tables, and i need to search for a word in this multiple tables, and it will display the content or the discription from the tables. omim number is the number from the table that related to the word i search for. can u generate the code for mi? show an example.. thx.. Link to comment Share on other sites More sharing options...
Dominic85 Posted April 11, 2006 Author Share Posted April 11, 2006 can anyone help mi with this? how to add more tables ? now i got 2 tables join together what if i want tojoin more tables, how should i do? add command on which line? SELECT av.Omim_NoFROM avINNER JOIN csON av.Omim_No=cs.Omim_NoWHERE av.Description LIKE '%LIVER%'OR cs.CS_Description LIKE '%LIVER%' Link to comment Share on other sites More sharing options...
Dominic85 Posted April 11, 2006 Author Share Posted April 11, 2006 CAN SOMEONE PLS HELP ME!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Link to comment Share on other sites More sharing options...
aspnetguy Posted April 11, 2006 Share Posted April 11, 2006 now i got multiple tables, and i need to search for a word in this multiple tables, and it will display the content or the discription from the tables. omim number is the number from the table that related to the word i search for. can u generate the code for mi? show an example.. thx..<{POST_SNAPBACK}> Based on this code you postedSELECT av.Omim_NoFROM avINNER JOIN csON av.Omim_No=cs.Omim_NoWHERE av.Description LIKE '%LIVER%'OR cs.CS_Description LIKE '%LIVER%'And if you want to display the description to the screen you will have to do thisSELECT av.Description,cs.CS_DescriptionFROM avINNER JOIN csON av.Omim_No=cs.Omim_NoWHERE av.Description LIKE '%LIVER%'OR cs.CS_Description LIKE '%LIVER%' in order to add more tables do this. SELECT av.Description,cs.CS_Description,nt.descriptionFROM avINNER JOIN csON av.Omim_No=cs.Omim_NoINNER JOIN newTable ntON av.Omim_No = nt.Omim_No  -- assuming newTable has Omim_NoWHERE av.Description LIKE '%LIVER%'OR cs.CS_Description LIKE '%LIVER%'OR nt.description LIKE '%LIVER%' Link to comment Share on other sites More sharing options...
Dominic85 Posted April 12, 2006 Author Share Posted April 12, 2006 i have done it.. is this correct? SELECT av.Omim_No,snp_idFROM avINNER JOIN csON av.Omim_No=cs.Omim_NoINNER JOIN ti ON cs.Omim_No=ti.Omim_NoINNER JOIN ti_alt_titleON ti.Omim_No=ti_alt_title.Omim_NoINNER JOIN txON ti_alt_title.Omim_No=tx.Omim_NoINNER JOIN OmimVarLocusIdSNPON tx.Omim_No=OmimVarLocusIdSNP.omim_idWHERE av.Description LIKE '%LIVER%'OR cs.CS_Description LIKE '%LIVER%'OR ti.Omim_Titles LIKE '%LIVER%'OR ti_alt_title.Omim_Alt_Titles LIKE '%LIVER%'OR tx.Omim_Text LIKE '%LIVER%' Link to comment Share on other sites More sharing options...
aspnetguy Posted April 12, 2006 Share Posted April 12, 2006 the only things that will be return in the dataset is av.Omim_Num and snp_idAre these the things you want to display to your screen???Whatever columns you SELECT is what is returned. Link to comment Share on other sites More sharing options...
Dominic85 Posted April 13, 2006 Author Share Posted April 13, 2006 the only things that will be return in the dataset is av.Omim_Num and snp_idAre these the things you want to display to your screen???Whatever columns you SELECT is what is returned.<{POST_SNAPBACK}> Yes Link to comment Share on other sites More sharing options...
aspnetguy Posted April 13, 2006 Share Posted April 13, 2006 then your query should work Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now