Syntax in infolink sql to implement sub (or innner) sql queries
I'm designing an infolink at this moment and i want to implement an infolink containing innner sql queries. Something like in the following example:
T1."ID" as "ID",
T1."Date" as "Date",
Where T2."ID" = T3."PersonID" and T2."Role" = 1 and T2."ElelementID"=T1."ID") as "SHORTNAME"
I've created the information link without the inner sql part and wanted to add that manually to the original query.
When i implement it like above (which works perfectly in another sql query tool) i get a message that the FROM T2,T3 is not expecte here.
I've tried all kind of ways to implement this subquery but failed up to now.
Can anyone show me what the correct way of doing this is?