Esql为一对多的关系 [英] Esql for One to many relationship

问题描述

我在客户和订单之间存在一对多的关系。

我希望有一个网格，其中将显示客户和订单的标题，即：

客户名称|订单。标题

什么是 eSql 声明才能获得如下图所示展平结果集

客户名称订单标题
丹尼相机
丹尼相机123
丹尼飞机

我尝试了下面的查询，但是从订单表中仅返回1条记录
选择

I have a one-to-many relationship between Customer and Orders.

I want to have a grid where the titles of customer and orders will be displayed, i.e.:

Customer.Name|Orders.Title

What would be the eSql statement to get a flatten resultset like the one shown below

CustomerName    OrderTitle
Danny                 Camera
Danny                 Camera123
Danny                 Plane

I tried the below query but its returning only 1 record from the order table
SELECT

ANYELEMENT（

    ANYELEMENT(

SELECT VALUE TOP（10）s.OrderTitle

        SELECT VALUE TOP (10) s.OrderTitle

来自e.Orders AS s）

        FROM e.Orders AS s )

AS OrderTitle

    AS OrderTitle

FROM DBEntities.Customer AS e

FROM DBEntities.Customer AS e

WHERE e.CustomerID = 2

请帮忙！

WHERE e.CustomerID = 2


Please help!

推荐答案

你好只需一个简单的连接：

You need just a simple join:

SELECT
    Customer.CustomerName,
    Order.Title
FROM
    Customer
    JOIN Order ON Customer.CustomerID = Order.CustomerID
WHERE
    Customer.CustomerID = 2

这应该得到你需要什么。

EulerOperator

This should get you what you need.

EulerOperator

这篇关于Esql为一对多的关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！