http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
says that for some sub-queries you can create temporary tables, but I
couldn't find any examples in the tutorial that show the use of a temporary
table. Are there any?
Or, if you're feeling generous, could you just tell me how to do this
Hi,
Bennett Haselton wrote:
--snip
select * from user left join MYTEMP on user.ID = MYTEMP.userid where
MYTEMP.userid IS NULL;
I bet that this approach will fail because you want the join to show you
records that aren't there. But it will show you something, and it will
show you more if you