topic Re: LEFT AND RIGHT JOIN?? in Application Development and Automation Discussions

LEFT AND RIGHT JOIN??

Former Member — Sat, 21 Jan 2006 14:25:25 GMT

Hi,

how can I do left and right join(CROSS JOIN)?

Thanks.

Re: LEFT AND RIGHT JOIN??

former_member184495 — Sat, 21 Jan 2006 14:34:19 GMT

hi,

to my knowledge, abap opensql supports only

'inner join' and 'left outer join'.

dont forget to reward points ,

and if you have something to share, please do.

cheers,

Aditya.

Re: LEFT AND RIGHT JOIN??

Former Member — Sat, 21 Jan 2006 14:58:13 GMT

HI,

Only 1)Inner join 2) right join and 3) left join exists.

http://www.w3schools.com/sql/sql_join.asp

http://www.query-ohne-namen.de/Forum/viewtopic.php?p=21

Re: LEFT AND RIGHT JOIN??

suresh_datti — Sat, 21 Jan 2006 14:59:49 GMT

Hi,

I agree with Aditya.. here is an example SELECT..


   select a~objid a~sobid a~endda
           b~stext
           c~chara
              into table t_quals
              from ( hrp1001                 as a
                    left outer join hrp1000 as b on a~objid  = b~objid
                                      and          a~otype   = b~otype )
                        inner join hrpad31 as c on a~adatanr = c~adatanr
             where a~otype  = c_type_q
               and a~plvar  = c_plvar
               and a~rsign  = c_rsign_b
               and a~relat  = c_relat_032
               and a~istat  = c_istat
               and a~endda >= w_begda
               and a~endda <= w_endda.

Regards,

Suresh Datti

Re: LEFT AND RIGHT JOIN??

Lakshmant1 — Sat, 21 Jan 2006 15:04:38 GMT

Hi Huseyin,

Have a look at demo programs

DEMO_SELECT_INNER_JOIN

DEMO_SELECT_LEFT_OUTER_JOIN

Hope this helps.

Thanks

Lakshman

Re: LEFT AND RIGHT JOIN??

Clemenss — Sat, 21 Jan 2006 21:14:00 GMT

maybe somebody can explain the logical differemces between the join type. I.E. I never heard of RIGHT or CROSS joins. Maybe I'm wrong but I think LEFT, INNER and LEFT INNER are just the same joins:

Both joined tables must have at least one record for the join condition.

LEFT OUTER or OUTER joins will fetch data if at least one of the two joined tables have a record for the join condition.

More suggestions welcome!

regards,

Clemens Li