I've given up on the LEFT JOIN thing I was poking at earlier, and have
successfully (at least at a mysql command prompt) designed the necessary
sequence of commands to get what I want ... in the form of a CREATE
TEMPORARY TABLE follow by two INSERT INTO ... SELECTs.
The only catch is ... it
Paul Chvostek writes:
The only catch is ... it won't go in PHP. The code looks fine, and I
suspect it's just a permission problem.
Indeed it seems that you need to have CREATE to do that. There
might be a good reason for it, but the only thing I can think
of is disk usage.
Do I *realy*