Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I would like to filter the rows of table F_SPRINT in order to include only the rows where the 'issue key' is in the AUGUST table:
I am trying to do something like this in SQL:
select *
from F_SPRINT
where issue_key in (select issue_key from August_table)
In QS this is what I wrote but it doesnt work, I am not sure what is the right code:
F_SPRINT:
LOAD
*
FROM F_SPRINT
WHERE [Issue Key] in (
LOAD [Issue Key]
FROM ISSUE_KEYS_AUGUST_2022
)
Could you please help me?
Thanks so much,
Electra
You can use exists for this