关联查询的问题
abcat 2005-05-12 04:13:00 mysql
有2张表,结构类似,要取2张表里的信息,按f_ctime倒序排,应该怎么写SQL语句?
table1
f_id,f_title,f_link,f_ctime
1,test,http://test.com/1.htm,2005:05:12 11:11:11
2,test,http://test.com/2.htm,2005:05:13 11:11:11
3,test,http://test.com/3.htm,2005:05:14 11:11:11
table2
f_id,f_title,f_link,f_ctime
1,test,http://test.com/1.htm,2005:05:10 11:11:11
2,test,http://test.com/2.htm,2005:05:17 11:11:11
3,test,http://test.com/3.htm,2005:05:18 11:11:11
需要得到这样的查询结果集:
f_id,f_title,f_link,f_ctime
3,test,http://test.com/3.htm,2005:05:18 11:11:11
2,test,http://test.com/2.htm,2005:05:17 11:11:11
3,test,http://test.com/3.htm,2005:05:14 11:11:11
2,test,http://test.com/2.htm,2005:05:13 11:11:11
1,test,http://test.com/1.htm,2005:05:12 11:11:11
1,test,http://test.com/1.htm,2005:05:10 11:11:11
……问题好象比较蠢 请各位XD多多包涵 不好意思 谢谢先 -_*