select * from table_0101 union select * from table_0102 union .........................
cqfeng(): 这一个不懂,好像不能正常执行呵? select * from HyForum_art union select * from HyForum_ad 这个是我在mysql_front表中的一个语句,报错可以用一楼的方法,这是一个统计的语句 SELECT count(HyForum_ad.id)+count(HyForum_art.id) FROM HyForum_ad ,HyForum_art or SELECT count(a.id)+count(b.id) FROM HyForum_ad as a ,HyForum_art as b 实在想不出为什么结果为什么不正确.
union
select * from table_0102
union
.........................
这一个不懂,好像不能正常执行呵?
select * from HyForum_art
union
select * from HyForum_ad
这个是我在mysql_front表中的一个语句,报错可以用一楼的方法,这是一个统计的语句
SELECT count(HyForum_ad.id)+count(HyForum_art.id) FROM HyForum_ad ,HyForum_art
or
SELECT count(a.id)+count(b.id) FROM HyForum_ad as a ,HyForum_art as b
实在想不出为什么结果为什么不正确.