gridField with 2 joined entities query

Question

Hi All, 
 I have to entities and I would like to create a gridField with their data 
 What is the best way to create a query with this join and then show the grid field ? 
 
 Thanks 
 Elia

lucasj · Accepted Answer

Hi Elia, 
 
My recommendation would be to create a view in your database that combines the relevant data from the two entities. You can then query this view to pull the data for your grid field. 
 
Thanks, 
Lucas