Inner join
Tengo este codigo y en tiempo de ejecucion me tira error de rsql Nro 23 y que no puede acceder a la sflight;
ahi va el codigo:
TYPES: BEGIN OF gs_vuelos,
carrid TYPE sflight-carrid,
fldate TYPE sflight-fldate,
price TYPE sflight-price,
money TYPE sflight-currency,
planetype TYPE sflight-planetype,
cityfrom TYPE spfli-cityfrom,
cityto TYPE spfli-cityto,
END OF gs_vuelos.
TYPES: BEGIN OF gs_vuelos1,
cityfrom TYPE spfli-cityfrom,
cityto TYPE spfli-cityto,
END OF gs_vuelos1.
TYPES: gt_tvuelos TYPE STANDARD TABLE OF gs_vuelos,
gt_vuelos1 TYPE STANDARD TABLE OF gs_vuelos1.
DATA: gt_vuelos TYPE gt_tvuelos,
gw_vuelos TYPE gs_vuelos,
gt_vuelos1 TYPE gt_vuelos1,
gw_vuelos1 TYPE gs_vuelos1,
l_total TYPE sflight-price.
SELECTION-SCREEN BEGIN OF BLOCK blk1 WITH FRAME.
PARAMETERS: p_carrid TYPE sflight-carrid.
SELECT-OPTIONS: s_date FOR sflight-fldate,
s_price FOR sflight-price.
SELECTION-SCREEN END OF BLOCK blk1.
SELECTION-SCREEN BEGIN OF BLOCK blk2 WITH FRAME.
PARAMETERS: p_write RADIOBUTTON GROUP a,
p_alv RADIOBUTTON GROUP a.
SELECTION-SCREEN END OF BLOCK blk2.
START-OF-SELECTION.
SELECT sflight~fldate sflight~price sflight~currency
sflight~planetype spfli~cityfrom spfli~cityto
FROM sflight INNER JOIN spfli ON sflight~carrid = spfli~carrid
AND sflight~connid = spfli~connid
INTO TABLE gt_vuelos
WHERE fldate IN s_date AND price IN s_price.
Bueno esto es parte del programa en lo referente al select ¿QUE ESTÁ MALLL?? POR FAVOR NECESITO RESPUESTAS! gRACIAAASSS....!
|