表A结构如下
表B结构如下
要根据A表中的all_pid的顺序来搜索B表中的数据
SELECT * from (SELECT a.uid,a.pid,b.all_pid FROM B(表名) AS a,A(表名) AS b WHERE a.uid=b.uid ) AS c ORDER BY c.uid ASC , LOCATE(c.pid,c.all_pid)
表A结构如下
表B结构如下
要根据A表中的all_pid的顺序来搜索B表中的数据
SELECT * from (SELECT a.uid,a.pid,b.all_pid FROM B(表名) AS a,A(表名) AS b WHERE a.uid=b.uid ) AS c ORDER BY c.uid ASC , LOCATE(c.pid,c.all_pid)