DW has always been limited when it comes to generating recordsets so I tend not to use it unless it is a simple get all or filter by one.
I use Navicat which can make much more complex queries which can then be copied and pasted into the advanced query window