Re: Nested SELECT statements problem

[Dan Nelson]

In the last episode (Aug 03), Pascal Dlisle said:
> Finally, I solved my problem by creating a temporary table that holds
> the result of the subquery.  So, it looks like this:
... 
> The only problem I see is when there are concurrent access to the
> table "livreTemp", e.g. when there are multiple simultaneous requests
> of that kind.  Is there a better way for achieving this under mySQL
> 3?

Use the CREATE TEMPORARY TABLE command, which creates tables which are
invisible to other client connections and are automatically dropped
when the client exits.

-- 
	Dan Nelson
	dnelson@stripped