Skip to Content
avatar image
Former Member

nested query

Dec 08, 2017 at 12:09 PM | 28 Views

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

SAP Business One
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Inga Babco
    Dec 13, 2017 at 01:46 PM

    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

    Add comment
    10|10000 characters needed characters exceeded