Inner Join Mutil DataSet

Inner Join Mutil DataSet

Posted by: duonghb53 on 23 June 2021, 4:34 am EST

• 

  duonghb53

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 June 2021, 4:34 am EST - Updated 30 September 2022, 4:38 pm EST

  Dear Support Team
  
  I have 2 DataSet: mAccounts & PL5_1 with fields same images below:
  
  

  

  1. mAccounts is DataSet result a query SQL
  2. And Can I using mAccounts a table to inner join in query of DataSet PL5_1,
     
     Example: PL5_1 query: select mAccounts .account_cd
     
     from table_x
     
     inner join DataSet.mAccounts
     
     on… ?
     
     Please help me.
     
     Thank you.
• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 24 June 2021, 1:29 am EST

  Hello,

  It is not possible to join the DataSets. However, you can refer to the following topic:
  
  https://www.grapecity.com/activereportsnet/docs/v15/online/nested-data-regions-bound-to-different-data.html

  Also, you can use the LookUpSet expression:
  
  https://www.grapecity.com/activereportsnet/docs/v15/online/lookup-set-function-in-data-regions.html

  Hope it helps.

  Thanks,
  
  Mohit

• 

  duonghb53

  • Post Options:
  • Link
    Copy

  Posted 24 June 2021, 5:10 am EST

  Dear Mohitg
  
  Thank you for your answers.