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.
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
