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