Single row query returns multiple lines
Hi ,
I am getting below error when calling a procedure in HANA Studio SQL editor
single-row query returns more than one row exception: single-row query returns more than one row: Please check lines: 250
Below is the query
SELECT
ARTICLE,
sum(stock_on_hand) as stock_on_hand
FROM :VAR_OUT1
group by ARTICLE;
What will be the reason?
Thanks,
Rithika
Rithika Kameshhwaren replied
Hi All,
Solved the issue myself. I have used werks = (select .... from <table>) instead of
werks IN (select .... from <table>)
Thanks,
Rithika