"SQL preview" and using branch names

[frank.peters]

I want to use two data sets in different branches

E.g.:

SELECT *
FROM `ri.foundry.main.dataset.XXXXXXXX-f4e7-4026-a9f7-TOPOLOGY` topology,
 `ri.foundry.main.dataset.YYYYYYYY-416e-433a-9e5b-DATA` data --@master
where
topology.id = data.id

topology is on branch "fpe/topology” and data on “master”

I get the following error message:
Could not access dataset ri.foundry.main.dataset.YYYYYYYY-416e-433a-9e5b-DATA on any of the branches [fpe/topology]

From “master”:
Could not access dataset ri.foundry.main.dataset.XXXXXXXX-f4e7-4026-a9f7-TOPOLOGY on any of the branches [master]

How do I specify a branch name for a dataset the “SQL Preview” window?

Something like:

SELECT *
FROM  `ri.foundry.main.dataset.YYYYYYYY-416e-433a-9e5b-DATA`@BRANCH_NAME

Thanks
Frank

[nicornk]

This should work:

SELECT col1 FROM {start_transaction_rid}:{end_transaction_rid}@{branch}.`{dataset_path_or_rid}` WHERE filterColumns = ‘value1’ LIMIT 1

[frank.peters]

@nicornk

SELECT col1 FROM {start_transaction_rid}:{end_transaction_rid}@{branch}.{dataset_path_or_rid} WHERE filterColumns = ‘value1’ LIMIT 1

It doen’t work:
is not a valid dataset identifier or mismatched input '.' '

Maybe I did something wrong when replacing the parameters.
Can you give a fully working example?

Thx
Frank