Kerry,
It gives me a solution and some reading.
No probs, here's some actual code that I hacked together on a
4.1-sommat-or-other database, an important thing to note is to be
careful of any Unique keys selected from the three individual tables as
they may no longer be unique of course once
Thanks Phil
It gives me a solution and some reading.
Kerry
-Original Message-
From: Philip Mather [mailto:[EMAIL PROTECTED]
Sent: 11 October 2006 10:02
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: How to build a single temporary table from 3 tables on the
fly