asked on
select
gln.description,
gln.posting_flag,
(
select distinct
gln2.acct_unit
from
lsfmigd.glnames gln2
where
gln2.posting_flag = 'S'
and gln.parent_obj_id = gln2.obj_id
and gln.company = gln2.company
and gln.acct_unit = gln2.acct_unit
and gln.company = gln.company) as Parent_Unit,
(
select distinct
gln2.description
from
lsfmigd.glnames gln2
where
gln2.posting_flag = 'S'
and gln.parent_obj_id = gln2.obj_id
and gln.company = gln2.company
and gln.acct_unit = gln2.acct_unit
and gln.company = gln2.company) as Parent_Desc
from
lsfmigd.glnames gln
where
gln.posting_flag = 'P'
and cast(gln.acct_unit as integer) = 10001
ASKER
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
TRUSTED BY
where gln.posting_flag = 'P'
and cast(gln.acct_unit as integer) = 10001
to:
Where gln.posting_flag in ('P','S')
and cast(gln.acct_unit as integer) in ('10001','100_NURSING_ADM'
or just leave off the last WHERE clause