多表关联查询

18405814695 · 发表于 2018-6-21 09:58:26

想在这里加上另一个表的关联，但是貌似加不了

18405814695 · 发表于 2018-6-21 10:01:47

在select 中添加概念，但是没有另一个模块下的概念可以添加

18405814695 · 发表于 2018-6-21 10:03:07

如图

18405814695 · 发表于 2018-6-21 10:04:07

如图

jishuang · 发表于 2018-6-21 10:40:12

http://bbs.wex5.com/forum.php?mod=viewthread&tid=40985

18405814695 · 发表于 2018-6-21 14:03:51

添加子查询后提示，

18405814695 · 发表于 2018-6-21 14:06:33

select D_product_info.*,(select COUNT(sout) from d_stock_out sout where D_product_info.contract_product_id = sout.contract_product_id AND sout.status = 1 ) as finish_out_num
from D_product_info D_product_info

jishuang · 发表于 2018-6-21 14:31:48

确认概念名大小写都正确吗？

18405814695 · 发表于 2018-6-21 14:33:46

刷新数据失败！ ,
执行KSQL出错, KSQL: SELECT D_product_info.*,(select COUNT(sout.stock_out_id) as finish_out_num from D_stock_out sout where D_product_info.contract_product_id = sout.contract_product_id AND sout.status = 1 ) as finish_out_num FROM D_product_info D_product_info WHERE ((D_product_info.status = 1 and D_product_info.contract_id = '866')) LIMIT 0, -1

18405814695 · 发表于 2018-6-21 14:35:49

jishuang 发表于 2018-6-21 14:31
确认概念名大小写都正确吗？

之前是概念名错了，现在是这个。。
刷新数据失败！ ,
执行KSQL出错, KSQL: SELECT D_product_info.*,(select COUNT(sout.stock_out_id) as finish_out_num from D_stock_out sout where D_product_info.contract_product_id = sout.contract_product_id AND sout.status = 1 ) as finish_out_num FROM D_product_info D_product_info WHERE ((D_product_info.status = 1 and D_product_info.contract_id = '866')) LIMIT 0, -1

		自动登录	找回密码
密码			注册

[处理中3] 多表关联查询