56,678
社区成员
发帖
与我相关
我的任务
分享
$query=mysql_query("select 表1.*,表2.good_jiage from 表1 left join(select good_jiage,add_date from 表2 order by add_date limit 1 )as pp on 表1.good_id=表2.yc_item_id") or die(mysql_error()) ;
mysql> select yc_name as `名称`,
-> yc_chandi as `产地`,
-> yc_guige as `规格`,
-> yc_jiage as `最新价格`
-> from yc_pinzhong a ,yc_jiage b
-> where a.yc_id=b.yc_item_id
-> and not exists (select 1 from yc_jiage where yc_item_id=b.yc_item_id and add_date>b.add_date);
+-------+------+------+----------+
| 名称 | 产地 | 规格 | 最新价格 |
+-------+------+------+----------+
| 白菜 | 安徽 | 统货 | 8.50 |
+-------+------+------+----------+
1 row in set (0.07 sec)
mysql>