Hi, sorry for question,
I would like to ask you experts, what is the way forward when you want to create a join between two tables. it is correct to do this:
- I create a new module
- here I create a subpanel with the join to another table, this join must be like:
select a.id, a.data, b.qty1, b.qty2 (select b.qty1 where type = 1) as Quantity 1, (select b.qty2 where type = 2) as Quantity 2 FROM activity a INNER JOIN work b ON a.id = b.id_activity
Now, does the result of this query go into a new table and then create a new form, just for this query?
Or is it enough to make the result appear on the screen?
According to SuiteCrm, how should we proceed?