这样:select * from product a,product b where b.productid=29 and a.Related_Product=b.Related_Product order by ProductID desc
mysql 4.1以上才支持子查询。你更改成以下语句试试select * from product P where P.productid in(select Related_Product from product PR where PR.productid=29) order by P.ProductID desc
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货