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
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