Skip to content
"AND" in our "JOIN"...
 
Notifications
Clear all

"AND" in our "JOIN" clause in "FROM" is not wokring as expected anymore

2 Posts
2 Users
0 Likes
378 Views
Posts: 2
Topic starter
(@senthilarumugam)
Active Member
Joined: 1 year ago

Hi

We used to get "AND" in our "JOIN" clause in "FROM" when we had multiple relations for the same field. This is not happening as expected anymore. Please advise. 

 

Thanks

1 Reply
Posts: 33
Admin
(@admin)
Member
Joined: 2 years ago
Hi there!
 
Ok so we did some research on our side for the Join not forming correctly on your end, and we haven't had any update in that section of the code since May of 2022. 
 
So the change was that the "AND" condition gets added only if you mark the relational field as "Primary" in the setup. This was one way to distinguish and let a user pick if the join used "AND" or not, as several clients were getting "AND" join in cases they didn't need it. 
 
 So can you please try and update this in your setup, and mark the columns to want to "AND" join on as Primary Key. 
 
Thanks
 
Dotnet Report Team
Reply
Share: