>> How about a UNION query...?
>Too bad MySQL doesn't support them yet ;)
Oops...sorry...I see it is on the TODO list.
Would a MERGE table not achieve the same result as a UNION query? It
appears that a MERGE table acts like a VIEW.
Eric if your Current and Temporary tables have identical structure, you may
consider a MERGE table as an option.
---------------------------------------------------------------------
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