Hi.
For many sub-queries, there exists a one-query work-around.
Most of the rest, you can work-around with some commands.
And then, there are a few around which one has to work in application.
There is a section in the manual about how to handle the lack of
sub-queries, which explains the most common work-around(s).
If you still don't know how to rewrite your query, post the sub-query
you want to / would use, and probably someone will give you the right
pointer where to start.
Bye,
Benjamin.
On Fri, Feb 02, 2001 at 11:33:11AM +1030, [EMAIL PROTECTED] wrote:
> I understand that MySQL does not support subqueries or nested
> queries. Is there a simple workaround or do I have to do a number of
> queries and manipulate them outside of MySQL? I am using PHP for
> server side code. Where can I look for answers?
>
> Terence
---------------------------------------------------------------------
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