MySQL sub-query error.

Good Morning everyone: I need help figuring out what is wrong with this query. I have tried to use the LEFT JOIN, but it doesn't solve the purpose. This is what I am trying to run: SELECT group_id,name,'SELECTED' FROM groups WHERE group_id = (SELECT group_id FROM user_groups WHERE use

privileges on a database

Hi all, I am new to mysql admin. I have created a database and set a user name and passwd for it using grant all privileges on MICDB.* to [EMAIL PROTECTED] identified by 'passdw' with grant option; Now the xxx user is able to login in to the database with the passwd , but he is not having

long query

if there is a long query i want to continue it in next like eg> Select canID from table1 where(text like '%a%' or text lik e '%b%') AND canID not in ( text like '%c%' or canID like '%d%') here i want to use some concatenation of lines any solution _

subselect

does subselect work in mySQL 3.23 ...i'm trying to exceute the following query ... Select can_ID from TABLE1 where (designation like '%sales%' or designation like '%marketing%') AND can_ID in (Select can_ID from TABLE1 where (designation like '%telecom%' or designation like '%software%')) i

subselect

does subselect work in mySQL 3.23 ...i'm trying to exceute the following query ... Select can_reg_no from candidate where (pres_org_curr_desig like '%sales%' or pres_org_curr_desig like '%marketing%') AND can_reg_no in ( Select can_reg_no from candidate where (pres_org_curr_desig like '%telec

rowid

i would like to use rowid in my query does mySQL support this ..if s how do i give in query please help... __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/

OutOfMemoryError

when i'm trying run a query which is having some 27k records always i get error OutOfMemoryError... any reasons.. __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/

subselect

does mysql version 3.23 support subqueries ...if no does latest version 4.0 support... __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/

rownum

does mySQL have "rowid" or "rownum" if yes please give an exampl __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com - Before posting, p

seagate crystal reports with mysql

can i create reports using seagate crystal reports with mySQL as backend. regards, gj __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ---

reports

sir, i would like to generate reports using mySQL but unable to get any information related to it could u please help me out or give some name of the sites that will get me to get some solution regards __ Do you Yahoo!? Yahoo! Mail Plus - Powerf