SELECT `id` , `time` , `title`FROM `think_infor`WHERE `type` LIKE '$k-%' UNION ALL SELECT `id` , `time` , `title`FROM `think_infor2`WHERE `type` LIKE '$k-%' ORDER BY `time` DESCLIMIT 0,6
用这个语句可以查询到表1和表2的最新6条信息。但是怎么判断记录是哪个表返回的？
或者有什么其他的方法可以实现，不想多次查询
回复讨论(解决方案)
你带上表名不就行了？
不过你能得到 表1和表2的最新6条信息 吗？
SELECT A.id AS aid , A.time AS atime , A.title AS atitle, B.id AS bid , B.time AS btime , B.title AS btitle
FROM think_infor AS A, think_infor2 AS B
WHERE A.type LIKE '$k-%' AND B.type=A.type
ORDER BY A.time DESC LIMIT 0,6
SELECT A.id AS aid , A.time AS atime , A.title AS atitle, B.id AS bid , B.time AS btime , B.title AS btitle
FROM think_infor AS A, think_infor2 AS B
WHERE A.type LIKE '$k-%' AND B.type=A.type
ORDER……
这个差不多，但是A表的记录是会有重复记录
SELECT `id` , `time` , `title`, 1 as cpfromFROM `think_infor`WHERE `type` LIKE '$k-%' UNION ALL SELECT `id` , `time` , `title` , 2 as cpfromFROM `think_infor2`WHERE `type` LIKE '$k-%' ORDER BY `time` DESCLIMIT 0,6
这个语句写的不是很清楚
引用 2 楼 yiwusuo 的回复:SELECT A.id AS aid , A.time AS atime , A.title AS atitle, B.id AS bid , B.time AS btime , B.title AS btitle
FROM think_infor AS A, think_infor2 AS B
WHERE A.type LIKE……
ORDER BY A.time DESC 后面加上：having count(A.id)=1
不就没重复了吗
我自己都觉得乱了，我还是说一下我想要的东西吧
有A表，B表，结构相同，数据不同，我想同时模糊查询一个字段`type`，选取两表中符合条件的前6条记录(根据`time`排序)
你自己写的不就可以吗？
SELECT `id` , `time` , `title`, 'think_infor' as tbl_name FROM `think_infor` WHERE `type` LIKE '$k-%'UNIONSELECT `id` , `time` , `title`, 'think_infor2' FROM `think_infor2` WHERE `type` LIKE '$k-%'ORDER BY `time` DESCLIMIT 0,6
加了个输出字段 tbl_name 用以区分数据来源
union all 改成 union 用于避免出现重复记录。不多加了来源就重复的也不重复了
你自己写的不就可以吗？
SQL code
?
123456789
SELECT `id` , `time` , `title`, 'think_infor' as tbl_name FROM `think_infor` WHERE `type` LIKE '$k-%'UNIONSELECT `id` , `time` , `title`, 'think_in……
SELECT 不存在的字段这也可以
你是指 'think_infor' as tbl_name 这个吗？
那么你认为 SELECT `id` as iidd FROM `think_infor` 这样可以吗？
肯定可以了，不就是给个名字么
接下来就不说了