#1
|
|||
|
|||
Inner
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 |
#2
|
|||
|
|||
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!! |
Herramientas | Buscar en Tema |
Desplegado | |
|
|