Dominic85 Posted March 30, 2006 Share Posted March 30, 2006 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 Link to comment Share on other sites More sharing options...
Guest meme_noob Posted March 30, 2006 Share Posted March 30, 2006 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<{POST_SNAPBACK}> pls email yr souce code to mi.... Link to comment Share on other sites More sharing options...
aspnetguy Posted March 30, 2006 Share Posted March 30, 2006 pls email yr souce code to mi....<{POST_SNAPBACK}> That is it...it is a full query. Link to comment Share on other sites More sharing options...
aspnetguy Posted March 30, 2006 Share Posted March 30, 2006 try this SELECT av.Omim_NoFROM av,cs,ti,ti_alt_title,txWHERE av.Omim_No = cs.Omim_NoAND av.Omim_No = ti.Omim_NoAND av.Omim_No = ti_alt_title.Omim_NoAND av.Omim_No = tx.Omim_No Link to comment Share on other sites More sharing options...
Dominic85 Posted March 31, 2006 Author Share Posted March 31, 2006 try thisSELECT av.Omim_NoFROM av,cs,ti,ti_alt_title,txWHERE av.Omim_No = cs.Omim_NoAND av.Omim_No = ti.Omim_NoAND av.Omim_No = ti_alt_title.Omim_NoAND av.Omim_No = tx.Omim_No <{POST_SNAPBACK}> 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.. Link to comment Share on other sites More sharing options...
Dominic85 Posted April 1, 2006 Author Share Posted April 1, 2006 can someone pls help mi.. thx alot.. Link to comment Share on other sites More sharing options...
Dominic85 Posted April 3, 2006 Author Share Posted April 3, 2006 can someone pls help me.. is urgent.. thx.. Link to comment Share on other sites More sharing options...
vijay Posted April 4, 2006 Share Posted April 4, 2006 HiPlease try with this select Omim_No from av,cs,ti,ti_alt_title,txwhere av.Description LIKE '%LIVER%'and (cs.CS_Description LIKE '%LIVER%' OR cs.CS_DATA LIKE LIVER%')and ti.Omim_Titles LIKE '%LIVER%'and ti_alt_title.Omim_Alt_Titles LIKE '%LIVER%'and tx.Omim_Text LIKE '%LIVER%'suppose this will help uRegardsVijay Link to comment Share on other sites More sharing options...
Dominic85 Posted April 4, 2006 Author Share Posted April 4, 2006 HiPlease try with this select Omim_No from av,cs,ti,ti_alt_title,txwhere av.Description LIKE '%LIVER%'and (cs.CS_Description LIKE '%LIVER%' OR cs.CS_DATA LIKE LIVER%')and ti.Omim_Titles LIKE '%LIVER%'and ti_alt_title.Omim_Alt_Titles LIKE '%LIVER%'and tx.Omim_Text LIKE '%LIVER%'suppose this will help uRegardsVijay<{POST_SNAPBACK}> what if i want to search every tables below? how is the code like? Link to comment Share on other sites More sharing options...
Dominic85 Posted April 6, 2006 Author Share Posted April 6, 2006 can someone pls help mi.. 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