topic Join statement in Application Development and Automation Discussions

Join statement

Former Member — Thu, 24 Aug 2006 12:57:56 GMT

Hi All ,

Is there any join statement like that retrives 'ALL THE DATA' from different table other than using select * statemnts...

thxs,

vin.

Re: Join statement

Former Member — Thu, 24 Aug 2006 12:59:44 GMT

JOIN statement is used only in conjunction with select statements. There is no JOIN statement without select statement.

What is your actual requirement?

here is a smaple usage for join:

<i><b>DATA: DATE LIKE SFLIGHT-FLDATE,

CARRID LIKE SFLIGHT-CARRID,

CONNID LIKE SFLIGHT-CONNID.

SELECT F_{CARRID F}CONNID F~FLDATE

INTO (CARRID, CONNID, DATE)

FROM SFLIGHT AS F INNER JOIN SPFLI AS P

ON F_{CARRID = P}CARRID AND

F_{CONNID = P}CONNID

WHERE P~CITYFROM = 'FRANKFURT'

AND P~CITYTO = 'NEW YORK'

AND F~FLDATE BETWEEN '20010910' AND '20010920'

AND F_{SEATSOCC < F}SEATSMAX.

WRITE: / DATE, CARRID, CONNID.

ENDSELECT.</b></i>

Re: Join statement

Former Member — Thu, 24 Aug 2006 13:02:15 GMT

Hi Vind,

Can you please elaborate your problem statement. Join is nothing to do with the col/fields, it works on record basis. For fields either you have to mention field names or you fetch all fields of the given table(s) using '*'.

Please make me clear if I'm getting you wrong.

Regards.

Shabbar

Re: Join statement

Former Member — Thu, 24 Aug 2006 13:02:42 GMT

Hi,

You can use field-groups to get data from diffrent

tables instead of join

field-group: header,items

insert mara-matnr into header.

insert makt-maktx into item .

extract item.

loop.

write:mara-matnr,mara-maktx.

endloop.

Regards

amole

Re: Join statement

Former Member — Thu, 24 Aug 2006 13:02:53 GMT

Join can only be used in conjunction with select statement but the other ways of retriving data from database tables is using LDBs

Regards

Anurag

Re: Join statement

Former Member — Thu, 24 Aug 2006 13:03:49 GMT

Hi Ravi ,

Usually join statments r like this a_{vbeln b}kunnr c~matnr which retrives data for tht particular fields from the table a , b , c but my requirment is to retrive all the feilds present in table a , b , c using join statemetns...

thxs,

vin

Re: Join statement

Former Member — Thu, 24 Aug 2006 13:07:54 GMT

Hi V,

To retrieve all the fields from Table(s) you just would have to write SELECT * from a instead of SELECT a~perner.

Join is just used to related two or more tables in question.

Hopefully this is the thing you were looking for.

Regards.

Re: Join statement

Former Member — Thu, 24 Aug 2006 13:09:41 GMT

I think u have go for FOR ALL ENTRIES in your select statemant.

Cheers

Badri

Re: Join statement

Former Member — Thu, 24 Aug 2006 13:15:00 GMT

Hi,

One option you can use is native sql

Exec sql.

select a.* b.* c.* ....

endexec.

Regards

Amole

Re: Join statement

Former Member — Thu, 24 Aug 2006 13:33:44 GMT

hi,

If you want to select all the fields from some table, then use * instead of individual fields. Join is used to relate table based on some fields.

Regards,

Richa

Re: Join statement

Former Member — Thu, 24 Aug 2006 13:45:48 GMT

Hi richa,

How to join the two r more differnt tables with all fields to display in an ALV and how to deifne the two r more tables is it ?? to pass the table to ALV..

DATA : BEGIN OF ITAB OCCURS 0.

INCLUDE STRUCTURE MARA.

INCLUDE STRUCTURE VBAK.

DATA : END OF ITAB.

THXS,

vin.