Re: Does MySQL support sub queries ?
Try looking at the bottom of any message. By the way, the output of your query is an empty set. Yen wrote: > > Thank you Jeremy, these really help!! I can't find the manual :D > > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 13, 2001 4:00 PM > To: Yen > Cc: [EMAIL PROTECTED] > Subject: Re: Does MySQL support sub queries ? > > On Fri, Apr 13, 2001 at 04:02:31PM +0800, Yen wrote: > > > > Does anyone know whether this MySQL support sub queries? > > Anyone who has checked the MySQL Manual does. > > (Hint: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html) > > Jeremy > > - > 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 - 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
RE: Does MySQL support sub queries ?
Thank you Jeremy, these really help!! I can't find the manual :D -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 4:00 PM To: Yen Cc: [EMAIL PROTECTED] Subject: Re: Does MySQL support sub queries ? On Fri, Apr 13, 2001 at 04:02:31PM +0800, Yen wrote: > > Does anyone know whether this MySQL support sub queries? Anyone who has checked the MySQL Manual does. (Hint: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html) Jeremy - 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
Re: Does MySQL support sub queries ?
Well I have managed to rewrite alot of my coding from MS SQL in a downward and more portable style using MySQL and ASP. I too have now hit apon where I need to have Sub queries on some basic searching of products. Rather than just telling people "the manual says..." that Sub Selects are missing, would anyone else like to show how to recreate the original example that Yen showed in his post, will work in MySQL (and with no giggery pokery with piping in from temporaty files)? I was wondering if a temporary heap table could be created and all done in multi line sql command (thus making it useable from an ADO recordset call in ASP and equivalent in php). Yens original code example: select ref from tool1 where detail = 'xxx' and ref in (select ref from tool1 where detail='yyy'); Seems so innocent and simple but I cant get my head around it Many thanks C
Re: Does MySQL support sub queries ?
On Fri, Apr 13, 2001 at 04:02:31PM +0800, Yen wrote: > > Does anyone know whether this MySQL support sub queries? Anyone who has checked the MySQL Manual does. (Hint: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html) Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
Does MySQL support sub queries ?
Hi, Does anyone know whether this MySQL support sub queries? such as: select ref from tool1 where detail = 'xxx' and ref in (select ref from tool1 where detail='yyy'); No matter it's within the same table or different table. However below is the error I've got, anyone can help? ERROR 1064: You have an error in your SQL syntax near 'select ref from tool1 where detail='yyy')' at line 1 Thank you. rgds, Yen - 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