Hi all,
Seems like a fairly simple one but getting some issues with a join in my physical layer.
Basically I want to join two tables together using the primary key but I want to also add that I want to see only active records using our active flag.
So for example, the join would look like:
a.key = b.key AND
a.active = 'Y' AND
b.active = 'Y'
This throws up the following error:
[nQSError:30001] Only columns, designated predicates and operators are allowed.
Interestingly, if I reverse the relationship of the join so it goes from being "one to many" to "many to one", it doesn't error, although this is obviously not an option going forward.
I have read that complex joins are not allowed in the Physical layer but not sure why that would be.
Cheers,
Adam
