is it possible ?????????????...

  • Thread starter Thread starter Anonymous
  • Start date Start date
A

Anonymous

Guest
I knw dat its possible to force mysql to create a temporary table with the option

SQL_BUFFER_RESULT

but i like to knw if its possible to do a SELECT in this table ??????? and if yes how?

My prob is that i wanna do a kind of left jonction on the same table ?!?...I knw its sounds wierd but its like dat....

So i have two queries
the first one:
SELECT LName, FName, forum.date, views, content, idlink, forum.id FROM member, forum WHERE forum.type LIKE 'topic' AND forum.authorID = member.ID ORDER BY date DESC

the second one
SELECT t1.*, t2.date FROM forum AS t1, forum AS t2 WHERE t1.id = t2.idlink ORDER BY t2.date DESC

I d like to do the second one on the result of the first one....
is it possible...
thanxs for your help
 
double post: http://www.php-forum.com/p/viewtopic.php?t=199

VERY annoying, please don't do it, just post you're question in the forum wich suits you're question most. (wich of the 2 you posted, is here, but I allready replyed in the other)
tnx.

Greetz Daan
 
Back
Top