一张表格同时显示主表字段和从表字段

ycgzl · 发表于 2015-7-23 10:40:22

一张表格同时显示主表字段和从表字段；需要类似 INNER JOIN 如何实现 527版本

jishuang · 发表于 2015-7-23 14:05:53

关联查询参考http://wex5.com/X5Knowledge/know ... 000171B83782F7.html

ycgzl · 发表于 2015-7-23 14:30:52

那个是主从；左连接； SELECT c, c.fCompanyName, COUNT(o) AS fOrderCount
FROM DEMO_Customers c
OPTIONAL JOIN DEMO_Orders o ON o.fCustomerID = c
GROUP BY
c, c.fCompanyName
ORDER BY
fOrderCount

我需要的是INNER JOIN 不是 LEFT JOIN ; 如果在标准动作中以明细表为主表时；没有办法显示内容啊

ycgzl · 发表于 2015-7-23 14:33:07

select Bb_PORequestEntry.*,Bb_PORequest.FBillNo as FBillNo
      , Bb_PORequest.FDate as FBillDate
      ,Bb_PORequest.FCreateUserName as FCreateUserName
      ,Bb_PORequest.FCreateDate as FCreateDate
      ,Bb_PORequest.FCheckUserName as FCheckUserName
      ,Bb_PORequest.FCheckDate as FCheckDate
      ,Bb_t_Item.FNumber as FNumber_New
      ,Bb_t_Item.FName as FName_New
from Bb_PORequestEntry Bb_PORequestEntry
   optional  join Bb_PORequest Bb_PORequest on Bb_PORequestEntry.fMainID = Bb_PORequest
   optional  join Bb_t_Item Bb_t_Item on Bb_PORequestEntry.FItemUUID = Bb_t_Item

ycgzl · 发表于 2015-7-23 14:33:40

这个查询没有办法显示字段啊

jishuang · 发表于 2015-7-23 16:55:38

这样的在子表的queryAction中写关联查询，不要在主表的queryAction中写关联查询

主表的会出现idColumn重复的问题

这个查询没有办法显示字段啊什么意思?

ycgzl · 发表于 2015-7-24 09:06:35

谢谢；可以结贴了

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

[结贴] 一张表格同时显示主表字段和从表字段

浏览过的版块