Skip to Content
0

nested query

Dec 08, 2017 at 12:09 PM

27

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Inga Babco Dec 13, 2017 at 01:46 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded