摘要:
select * from MiscShipRecord m left join BarcodeMaster b on m.ItemCode=b.ItemMasterCode and m.LotNo=d.LotNo where m.id=new ObjectId("62eb55390a3211002 阅读全文
摘要:
select * from MiscShipRecord left join DeliveryRecord on MiscShipRecord._id=new ObjectId(DeliveryRecord.SourceEntityID) Mongodb实现方式: db.MiscShipRecord 阅读全文
摘要:
SELECT * FROM customer_linkman WHERE customer_id = #{customerLinkman.customerId} and id != #{customerLinkman.id} and is_deleted = 0 and ifnull(linkman 阅读全文
摘要:
UPDATE clue INNER JOIN sys_node ON clue.id=sys_node.rel_id AND sys_node.wf_name='clue' SET clue.`status`=1,clue.node_name='线索分配',clue.node_time=sys_no 阅读全文