Hi Folks,
Probably not much versed in SQL/PL/SQL, as I am seeking a bit of a hints here. I have put together a query which runs fine when I am passing a fixed value, like below:
.....
VAR issueId number
exec :issueId :='41'
SELECT
Id AS Key, LayoutId AS Value
FROM
CBS_BRIEFS
WHERE
IssueId = :issueId
AND EditionCode = (SELECT EditionCode FROM CBS_BRIEFS WHERE Id = 21)
....
==> Yet, I am looking after a way of having issueId out of a query like:
issueId := (SELECT IssueId FROM CBS_BRIEFS WHERE Id = 21)
instead of having assigned fixed values.
Any clues would be appreciated.
Thanks in advance