Morning guys, I am having a issue, I need to make a inner join in soql... Example:
- Process instance( table1)
- Process instance step(table 2)
I need to create a table mixing both tables, Id tabel 1 is process instance id in the 2, Table 1 primary key is a forien Key in table 2...
But soql will not support joins for tables I have to write a complete code for this... do you know any other way apart form Apex class?