Jump to content

Dominic85

Members
  • Posts

    21
  • Joined

  • Last visited

Dominic85's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. 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%'
  2. CAN SOMEONE PLS HELP ME!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
  3. 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%'
  4. 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..
  5. 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..
  6. 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?
  7. Dominic85

    HELP!

    is there any books i can refer to? pls help mi..
  8. Dominic85

    HELP!

    can someone pls help mi?
  9. what if i want to search every tables below? how is the code like?
  10. Dominic85

    HELP!

    can u help mi with the code?
  11. Dominic85

    HELP!

    I have put this into one database.. how to search the keywords from the tables? i mean every tables.. wad is the code? can someone help mi out? is urgent.. thx a million..
×
×
  • Create New...