INCLUDE zsqlexplorerf08.
TABLES:zpp009.
data:begin of xflight occurs 0,
WERKS 孕妇逛街打一成语like zpp009-BERID,
end of xflight.
SELECT BERID FROM zpp009 into xflight.
ENDSELECT.
write:/ xflight.
TABLES:spfli.
DATA sitab LIKE spfli.
SELECT萌宝宝图片 家校联系情况记录SINGLE
carrid connid airpfrom airpto
FROM spfli
INTO CORRESPONDING FIELDS OF sitab
WHERE carrid = 'UA' AND connid = '3504'.
write:/ sitab-carrid,/ sitab-connid,/ sitab-airpfrom,/ sitab-airpto.
& End
TABLES sbook.
DATA:count1 TYPE i,sum1 TYPE p DECIMALS 2, avg1 TYPE f. "定义三个变量
DATA:connid LIKE sbook-connid.
SELECT connid COUNT(*) SUM( luggweight ) AVG闭月羞花什么意思( luggweight )
into (connid,count1,sum1,avg1)
from sbook
where
carrid = 'LH' and fldate = '19950228'
group by connid.
WRITE:/ connid,count1,sum1,avg1.
CHECK sum1 > 10.
WRITE:/ 'the sum weight > 10'.
ENDSELECT.
TABLES:spfli,sflight.
DATA:BEGIN OF xflight OCCURS 0, "定义一个结构体
头疼按什么穴位
airpfrom LIKE spfli-airpfrom,
airpto LIKE spfli-airpto,
fldate LIKE sflight-fldate,
deptime LIKE spfli-deptime,
END OF xflight.
SELECT a~airpfrom a~airpto b~fldate a~deptime
INTO CORRESPONDING FIELDS OF TABLE xflight
FROM spfli AS a INNER JOIN sflight AS b
ON a~carrid = b~carrid
AND a~connid = b~connid
汪峰身高 WHERE a~carrid = 'LH'
ORDER BY a~airpfrom a~airpto b~fldate a~deptime.
DATA:BEGIN OF xpfli OCCURS 0, "定义的结构体
carrid LIKE spfli-carrid,
connid LIKE繁体字符号 spfli-connid,
END OF xpfli.
DATA:xflight LIKE TABLE OF sflight WITH HEADER LINE.
SELECT carrid connid
INTO CORRESPONDING FIELDS OF TABLE xpfli
FROM spfli WHERE carrid = 'LH'.
IF NOT海洋动物表演 xpfli[] IS INITIAL. "判断是否为空
SELECT * FROM sflight
INTO CORRESPONDING FIELDS OF TABLE xflight
FOR ALL ENTRIES IN xpfli
WHERE carrid = xpfli-carrid AND connid = xpfli-connid.
ENDIF.
