Dominic85
-
Posts
21 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Everything posted by Dominic85
-
Yes
-
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%'
-
CAN SOMEONE PLS HELP ME!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
-
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%'
-
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..
-
oh.. come on.. pls help mi..
-
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..
-
hey can someone pls help mi?
-
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?
-
can someone pls help mi..
-
what if i want to search every tables below? how is the code like?
-
can someone pls help me.. is urgent.. thx..
-
can someone pls help mi.. thx alot..
-
The code u post is display all the data. but i jus want to search by the key word from the description.can u help mi with this? my database is called Omim and inside Omim i have 5 tables as i snapshot. i want to search for the key word "LIVER" but it display all the data that not related to the key word "LIVER". can you help mi to solve the below code? it just can't search for the key word "LIVER" from the Description, CS_Description, CS_DATA, Omim_Titles, Omim_Alt_Titles, Omim_Text. SELECT av.*,cs.*,ti.*,ti_alt_title.*,tx.*FROM av,cs,ti,ti_alt_title,txWHERE av.Omim_No = cs.Omim_No AND av.Omim_No = ti.Omim_NoAND av.Omim_No = ti_alt_title.Omim_NoAND av.Omim_No = tx.Omim_NoOR Description LIKE '%LIVER%'OR CS_Description LIKE '%LIVER%'OR CS_DATA LIKE '%LIVER%'OR Omim_Titles LIKE '%LIVER%'OR Omim_Alt_Titles LIKE '%LIVER%'OR Omim_Text LIKE '%LIVER% The problem is i can't search for the key word "LIVER".It should be display the result of the Omim_No and other information related to the key word. pls help mi thx a lot..
-
can anyone help mi with this? from my code FROM i can't put FROM av,cs,ti,ti_alt_title,tx . Is there any solution for this?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%'ORDER BY Omim_No ASC