MarkMpn / Sql4Cds

SQL 4 CDS core engine and XrmToolbox tool
MIT License
74 stars 22 forks source link

[Bug](V9.2.0) LEFT OUTER JOIN on metadata gives wrong result #516

Closed hiroyuki0415 closed 1 month ago

hiroyuki0415 commented 1 month ago

LEFT OUTER JOIN behaves like INNER JOIN:

SELECT a.entitylogicalname,
       a.attributetypename,
       a.logicalname,
       a.targets,
       p.logicalname
FROM   metadata.attribute AS a
       LEFT OUTER JOIN
       metadata.entity AS p
       ON a.targets = p.logicalname
WHERE  a.entitylogicalname IN ('team');

スクリーンショット 2024-07-16 12 42 16