Question

Sideroute in query...

0

Suppose I create a Data_Set from a number of direct associations like A/B/C/D being all parent-child relationships. Now there is an association from B to E, just containing a code of some kind. What is the syntax if I want to retrieve a value in E, related from B, in this query? Thanks!

asked 2013-12-08

Gerard Veurink

2 answers

Chris de Gelder · Answer 1 · 2013-12-09

FROM press ctrl+space B

SELECT press ctrl+space B_E/Code

Gerard Veurink · Answer 2 · 2013-12-11

Thanks Chris. This is de OQL I have: {SELECT ... FROM Product INNER JOIN Product/ReqProduct/Req/ReqPS/PS/PSP/P/iPP/iPr WHERE ...} now I need to include ReqU via the Req_ReqU association. Can U show me the correct OQL? Thanx!