Brad Eacker wrote: > Jigal van Hemert writes: > >Do you mean temporary tables? These are only necessary when there's no way > >to solve the problem with a join. > > Actually a temporary table can be used with a join to do what is usually > knows as a sub-select or sub query. In this fashion you select the elements > that would normally be part of an 'IN (select ...)' into a temporary table. > Then join the selection table with the newly created temporary to get the > final data set desired.
Hey Brad, I tried to keep things as simple as possible for this guy, since he could neither get a simple join working nor could he display the resulting record set. No need to bother him with things llike subqueries IMHO ;-) Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
