Hello;
I have a query :
select * from
(
select t0.field1, t0.field2 ,t0 . .......
from table t0
where t0.field1 = [%0]
) as tb1
the inner query executes fine
when I run the outer query the query does not prompts for parameter
and does not return ant results.
thanks
dov
The first comment line is important:
/*SELECT * from OITM t0 where t0.ItemCode = [%0] */
SELECT * FROM
select t0.ItemCode, T0.ItemName
from OITM t0 where t0.ItemCode = [%0]
) AS tb1
You already have an active moderator alert for this content.
Add comment