I'm trying to pull data into a table from two trees. The card on which I'm trying to perform the query is on the tree 'Planning tree - story' but I also want some data from the 'BP tree'. Bothe trees have card type = story.
I've had a few goes (see below), which should give an idea of what I'm trying to do, but I'm not sure if I'm going totally up the wrong path or if this is even possible.
I'm very new to this so any help would be greatly appreciated.
table query: SELECT 'Story.number', 'Story.name', 'Story.story status', 'Story.planning estimate', 'BP.DSG mingle number' FROM TREE 'BP Tree' WHERE ('type' = 'story' OR 'type' = 'BP') AND 'Sprint' = THIS CARD
table query: ((SELECT 'DSG mingle number' FROM TREE 'BP Tree' WHERE 'type' = 'BP') AND (SELECT name FROM TREE 'BP Tree' WHERE 'type' = 'story' AND 'Sprint' = THIS CARD ))