topic select query in Application Development and Automation Discussions

select query

Former Member — Fri, 04 Apr 2008 13:07:31 GMT

Can you please tel me how to write this select query using for all entries......

SELECT i~tplnr

f~pltxt

i~invnr

i~objnr

i~erdat

i~fltyp

i~iwerk

a~class

k~clint

INTO CORRESPONDING FIELDS OF TABLE OUTPUT

FROM ( ( ( iflot AS i INNER JOIN iflo AS f ON f_{tplnr = i}tplnr )

INNER JOIN kssk AS k ON k_{objek = i}tplnr )

INNER JOIN klah AS a ON a_{clint = k}clint )

WHERE i~tplnr EQ tplnr .

points will be definitely awarded......

Re: select query

Former Member — Fri, 04 Apr 2008 13:11:03 GMT

Hi,

Following is the select query

select

Fld1

fld2

fld3

from dbtable into corresponding fields of table itab2

for all entries in itab1

where fld1 = itab1-fld1.

REWARD IF USEFUL

Re: select query

Former Member — Fri, 04 Apr 2008 13:18:46 GMT

Hi Preet

SELECT IFLOT~TPLNR

IFLOT~INVNR

IFLOT~OBJNR

IFLOT~ERDAT

IFLOT~FLTYP

IFLOT~IWERK

IFLO~PLTXT

KLAH~CLASS

KSSK~CLINT

INTO CORRESPONDING FIELDS OF TABLE OUTPUT

FROM IFLOT INNER JOIN IFLO ON IFLO_{TPLNR = IFLOT}TPLNR

INNER JOIN KSSK_{OBJEK = IFLOT}TPLNR

INNER JOIN KLAH_{CLINT = KSSK}CLINT

WHERE I~TPLNR EQ TPLNR.

Reward me points

Pari

Re: select query

Former Member — Fri, 04 Apr 2008 13:20:38 GMT

Hi,

i dont want to use inner join in this query....