Help with nested sql-query
Posted: Sat Oct 09, 2004 8:02 am
Hi
This nested query gives me a syntax error:
SELECT starttime, duration FROM mos_poly_activities WHERE actID = (SELECT lastactivity FROM mos_poly_lines WHERE linename = 'nettlinje');
But if I run the same two queries independently with the outer query using the result from the inner one, everything is ok.
The final result is an empty set, but that shouldn't effect the nested query I think.
Anyone know how to fix this error?
Regards tores
This nested query gives me a syntax error:
SELECT starttime, duration FROM mos_poly_activities WHERE actID = (SELECT lastactivity FROM mos_poly_lines WHERE linename = 'nettlinje');
But if I run the same two queries independently with the outer query using the result from the inner one, everything is ok.
The final result is an empty set, but that shouldn't effect the nested query I think.
Anyone know how to fix this error?
Regards tores