Hi ,

I am developing a session to where i want to store the BOM items with his Main and child item in single Colum.

So i have written following query in SQL 2000

select sitm from tibom010
where
mitm="ITM003"
or
mitm
in(
select it.mitm
from tibom010 i
right outer join tibom010 it
on i.sitm=it.mitm
where i.mitm="ITM003"
)


How can i use this query in baan?

Regards
Rajesh

Well I would not use that - I would just do something like this:

Select tibom010.mitm, tibom010.sitm
from tibom010
where tibom010.mitm = :someitm
selectdo
newtable.citm = tibom010.mitm & tibom010.sitm
db.insert(tnewtable)
commit.transaction()
endselect

Put it in a library and you can call it as needed as you walk through the BOM.