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..