Hello,
I got 2 tables:
Table 1:
T | Key | Summary | Epic Link | Parent Link
T can be a Epic. Then it has a Epic Link
Or T can be a Story. Then it has a Parent Link.
Table 2:
T | Key | Summary
With table-transformer I want to get a table with all elements of table 1 plus if it has a parent link then the extra fields of T2, or if it has a Epic Link then the extra fields of T2.
My sample with only Epic Links is:
SELECT T1.'Key', T2.'Key' as 'Parent Key'
FROM T1 INNER JOIN T2 ON T1.'Epic Link' = T2.'Key'
But it gives me no entries.
Thank you
