mysql - 2个表格查询并花费一个值

Question

2 tabbells 查询并花费 subid 一个潜在客户和销售表的值 如果有条件，我想阅读 subid

select l.,s.usubid 
from leadkamp as l,salekamp as s 
WHERE l.lastupdate>='2019-06-01 00:00:01' and 
      l.lastupdate<='2019-06-27 23:59:59' and 
      s.lastupdate>='2019-06-01 00:00:01' and 
      s.lastupdate<='2019-06-27 23:59:59' and 
      l.`user` = '2' and s.`user` = '2';

标签： mysql