This content has been marked as final. Show 2 replies
Your select list from query receives a static SQL. That SQL doesn't "see" your s.source_id value.
But it would work like this:
where b.source_id = ' || s.SOURCE_ID)
You would be concatenation the value to the SQL. It's not ideal but it will work.
That did work! Thanks for that. Seems like a rather convoluted way to do it but I won't complain if it gets the job done.
Now to just work out how to update the table based on this value, wasn't as straight forward as I thought it was at first..