Inner

[ongo]

Buenas,

Me gustaría si alguien me pudiese dar una clase rápida sobre inner join, left outer join... o sea los distinto join que hay.

Muchas gracias

[RAMONES]

te paso un ejemplo de inner join a 2 tablas, es un inner sin usar ALIAS.


types: begin of t_tabla,
countryfr type spfli-countryfr,
cityfrom type spfli-cityfrom,
airpfrom type spfli-airpfrom,
countryto type spfli-countryto,
cityto type spfli-cityto,
fldate type sflight-fldate,
price type sflight-price,
currency type sflight-currency,
planetype type sflight-planetype,
seatsmax type sflight-seatsmax,
seatsocc type sflight-seatsocc,
end of t_tabla.

data: it_salida type TABLE OF t_tabla,
wa_salida type t_tabla,
connid type spfli-connid,
carrid type spfli-carrid.

SELECT-OPTIONS: s_connid for connid.
SELECT-OPTIONS: s_carrid for carrid.

select spfli~countryfr spfli~cityfrom spfli~airpfrom spfli~countryto
spfli~cityto sflight~fldate sflight~price sflight~currency
sflight~planetype sflight~seatsmax sflight~seatsocc
into corresponding fields of table it_salida
from spfli "as spfli
inner join sflight "as sflight
on spfli~carrid = sflight~carrid
and spfli~connid = sflight~connid
where spfli~connid in s_connid
and spfli~carrid in s_carrid.



SALUDOS!!