topic Re: Regd Select Q in Application Development and Automation Discussions

Regd Select Q

SG141 — Fri, 22 Jun 2007 16:50:01 GMT

I am writing a select query...


  select l~lgpla
         l~lgnum
         l~lgtyp
         l~lgber
         l~verif
         m~matnr
         into table t_bin
         from lagp as l
         left outer join
         lqua as m
         on l~lgpla = m~lgpla
         where l~lgtyp = p_lgtyp
         and   l~lgnum = p_lgnum
         and   verif < l_date
         and   verif ne ' '.

I want to retrieve all lgpla with has no matnr...(matnr is empty)..

How can i modify the code..

Re: Regd Select Q

Former Member — Fri, 22 Jun 2007 16:58:39 GMT

Try like this :

select l~lgpla

l~lgnum

l~lgtyp

l~lgber

l~verif

m~matnr

into table t_bin

from lagp as l

left outer join

lqua as m

on l_{lgpla = m}lgpla

where l~lgtyp = p_lgtyp

<b> and m~matnr = ''</b>

and l~lgnum = p_lgnum

and verif < l_date

and verif ne ' '.

Re: Regd Select Q

SG141 — Fri, 22 Jun 2007 17:01:43 GMT

Seshu it's working

I want to write two select queries

first I'll lgpla etc from lagp table.

then using matnr from lqua table.

How to write that query.

Re: Regd Select Q

Former Member — Fri, 22 Jun 2007 17:21:49 GMT

declare internal table as you required

select * into table int_table

from lqua as a inner join lagp as b on a_{lgnum = b}lgnum

where b~matnr = ''.

I would suggest always inner join than outer join -> outer join is performance issue.

Thanks

Seshu