Hi ,
i have Table "A" and i need to join Table "B" and Table "C" to Table "A"
EX:
while select X from A where A.ID == '5'
Join B where A.BID==B.ID
join C where A.CID==C.ID
any help to make right join between three tables
*This post is locked for comments
AX does not do a right join. You can put your "right" table as top of the select statement, and do an outer join on the "left" table. This way it will return all rows as a SQL right join would for the right table, and only rows that match based on the relation from the left table.
Results are identical to what you would expect with a right join.
So we do make use of the left outer join T-SQL syntax here instead, see what Mahmoud has linked.
Hi,
Code whatever you are using seems to be fine, are you looking for sql statement for the same.
Alternatively you can use this:
while select X from A
Join B where A.BID==B.ID
join C where A.CID==C.ID
&& A.ID == '5'
{
// Your code.
}
SQL STATEMENT:
select A.X
inner join B on A.BID = B.BID
inner join C on C.ID = A.CID
where A.ID = 5
you can check this link
community.dynamics.com/.../how-joins-in-x-select-statement-are-translated-into-t-sql
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
50
#3
shanawaz davood basha
6
Share
Report
All responses (
Answers (
