Well I actually noticed a press release a few days ago saying that the latest version (4.0.10??) is supporting sub-slelect... please check the website.
this following should be working: select nome from categorias, categoriamembro where categoriamembro.id_categoria = categorias.categoria and categoriamembro.membro = 1807; > (select id_categoria > from categoriamembro where id_membro=1807)" --- [EMAIL PROTECTED] wrote: > > Sadly MySQL does not support sub-selects yet. Take a > look at the manual for > suggestions of ways around it. > > Keith > > > > > Extranet > [EMAIL PROTECTED] - 06/02/2003 02:31 > > To: mysql > > cc: > > > Subject: Can mysql execute this ? how can i do > this ? > > > Is this possible > > "select nome from categorias where id_categoria in > (select id_categoria > from categoriamembro where id_membro=1807)" > > in MySQL > > > Thks > > [MsR] > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > This message and any attachments (the "message") is > intended solely for the addressees and is > confidential. > If you receive this message in error, please delete > it and > immediately notify the sender. Any use not in accord > with > its purpose, any dissemination or disclosure, either > whole > or partial, is prohibited except formal approval. > The internet > can not guarantee the integrity of this message. > BNP PARIBAS (and its subsidiaries) shall (will) not > therefore be liable for the message if modified. > > > --------------------------------------------- > > Ce message et toutes les pieces jointes (ci-apres le > > "message") sont etablis a l'intention exclusive de > ses > destinataires et sont confidentiels. Si vous recevez > ce > message par erreur, merci de le detruire et d'en > avertir > immediatement l'expediteur. Toute utilisation de ce > message non conforme a sa destination, toute > diffusion > ou toute publication, totale ou partielle, est > interdite, sauf > autorisation expresse. L'internet ne permettant pas > d'assurer l'integrite de ce message, BNP PARIBAS (et > ses > filiales) decline(nt) toute responsabilite au titre > de ce > message, dans l'hypothese ou il aurait ete modifie. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php