Error added: 2021-02-19T15:19:40Z
The problem I'm having is that the query runs fine in SQL Developer and returns the correct data, the subqueries only return a single row, but yet I get this error when running the same query in NodeJS. My query is this (anonymised): SELECT A, B , C FROM T1 WHERE PS = (SELECT SS FROM T2 WHERE I = :param) AND DD = (SELECT MAX(DD) FROM T1 WHERE PS = (SELECT SS FROM T2 WHERE I = :param))
If you know the answer, please add your own solution below.
If you don't know, but find out later, please come back and share your answer - there will be other people
struggling with this too.
If you want to be notified via email when this is solved, enter your email address here: