表一 t_stock
| stock_id | quantity | drug_id || 1 | 5 | 1 |表二 t_drug_info;| drug_id | drug_name | general_name | package_standard | flag | drug_standard | lot_number | period | unit | | 1 | yaotou | sunway | 10 | 盒 | 10/合 | 2009-12-12 | 120 | 合 | 这里是表二,上面下出来不好看
production_place | producer_id | supplier_id |shanghai | 1 | 1 |
表三 t_in_history
in_id | quantity | enter_date | operater | drug_id || 1 | 20 | 2009-10-01 00:00:00| sky | 1 |
求 t_stock对应的药表三里面只要找到enter_date这条记录的
其他的字段信息都要显示出来
| stock_id | quantity | drug_id || 1 | 5 | 1 |表二 t_drug_info;| drug_id | drug_name | general_name | package_standard | flag | drug_standard | lot_number | period | unit | | 1 | yaotou | sunway | 10 | 盒 | 10/合 | 2009-12-12 | 120 | 合 | 这里是表二,上面下出来不好看
production_place | producer_id | supplier_id |shanghai | 1 | 1 |
表三 t_in_history
in_id | quantity | enter_date | operater | drug_id || 1 | 20 | 2009-10-01 00:00:00| sky | 1 |
求 t_stock对应的药表三里面只要找到enter_date这条记录的
其他的字段信息都要显示出来
where t1.drug_id=t2.drug_id and t1.drug_id=t3.drug_id and t3.enter_date is not null;