Expression Rule with "Left Join" and "Inner Join" - SQL

Question

Hi everyone, 
 Is there some way to include "Left Join" and "Inner Join" inside an expression rule with "a!queryEntity"? 
 Thanks, 
 Josue

paulc919 · Accepted Answer

If you're looking to join on other tables then I'd recommend creating a SQL View that does the data manipulation and then having your queryEntity read the view. Care will be needed on the View access depending on expected data volumes and growth of data on the tables being joined together.

sindhug · Answer

Please go through below link. You will get basic understanding on how to create a view. www.w3resource.com/.../creating-view.php After creating the view , Create a Data type(CDT) for that view and map it to Data store. Create a Query entity based on your requirement.This would resolve your issue Thanks, Sindhu

dineshd0001 · Answer

I you don't want to create view between the tables we can achieve this using Execute Stored Procedure plugin where we can execute the SQL statements and it will return the result in dictionary.We can use this approach if the data volume is high.