这个代码 在加一列写成视图形式怎么写呀

Question

 SELECT     CONVERT(NVARCHAR, RH.REQ_ID) + '-' + CONVERT(NVARCHAR, EEO.EXP_TYPE) + CONVERT(NVARCHAR, EEO.CURRENCY_TYPE) + '-S' AS ID, RH.REQ_ID, 
                      EEO.EXP_TYPE,EEO.ISHAVEBREAKFAST, EEO.CURRENCY_TYPE, SUM(EEO.EXP_PRICE) AS EXP_PRICE, SUM(EEO.RMB_PRICE) AS RMB_PRICE, SUM(EEO.ACT_EXP_PRICE) 
                      AS ACT_EXP_PRICE ,SUM(EEO.ACT_RMB_PRICE) AS ACT_RMB_PRICE, 'Total' AS CONTENT, '' AS MEMO
FROM         REQUEST_HEAD RH, EXP_EVECTION_OTHERS EEO
WHERE     RH.REQ_ID = EEO.REQ_ID
GROUP BY RH.REQ_ID, EEO.EXP_TYPE, EEO.CURRENCY_TYPE
UNION
SELECT     CONVERT(NVARCHAR, RH.REQ_ID) + '-' + CONVERT(NVARCHAR, EEO.EXP_TYPE) + '-' + CONVERT(NVARCHAR, EEO.EXP_ID) AS ID, RH.REQ_ID, EEO.EXP_TYPE, 
                      EEO.CURRENCY_TYPE, EEO.EXP_PRICE, EEO.RMB_PRICE, EEO.ACT_EXP_PRICE,EEO.ISHAVEBREAKFAST, EEO.ACT_RMB_PRICE, CONVERT(NVARCHAR(10), EEO.OCCUR_DATE, 120) 
                      AS CONTENT, EEO.EXP_DESC AS MEMO
FROM         REQUEST_HEAD RH, EXP_EVECTION_OTHERS EEO
WHERE     RH.REQ_ID = EEO.REQ_ID;

在加一列 （EXP_EVECTION_OTHERS这个表中的别名EEO的 ISHAVEBREAKFAST这个列 怎么写呀 求各位大神帮忙）

Answer 1

      SELECT CONVERT(NVARCHAR,rh.req_id)
               + '-'
               + CONVERT(NVARCHAR,eeo.exp_type)
               + CONVERT(NVARCHAR,eeo.currency_type)
               + '-S' AS id,
             rh.req_id,
             eeo.exp_type,
             eeo.ishavebreakfast,
             eeo.currency_type,
             SUM(eeo.exp_price) AS exp_price,
             SUM(eeo.rmb_price) AS rmb_price,
             SUM(eeo.act_exp_price) AS act_exp_price,
             SUM(eeo.act_rmb_price) AS act_rmb_price,
             'Total' AS content,
             '' AS memo,
             eeo.ISHAVEBREAKFAST
        FROM request_head rh,
             exp_evection_others eeo
       WHERE rh.req_id = eeo.req_id
    GROUP BY rh.req_id,eeo.exp_type,eeo.currency_type, eeo.ISHAVEBREAKFAST
    UNION 
    SELECT CONVERT(NVARCHAR,rh.req_id)
             + '-'
             + CONVERT(NVARCHAR,eeo.exp_type)
             + '-'
             + CONVERT(NVARCHAR,eeo.exp_id) AS id,
           rh.req_id,
           eeo.exp_type,
           eeo.currency_type,
           eeo.exp_price,
           eeo.rmb_price,
           eeo.act_exp_price,
           eeo.ishavebreakfast,
           eeo.act_rmb_price,
           CONVERT(NVARCHAR(10),eeo.occur_date,120) AS content,
           eeo.exp_desc AS memo,
           eeo.ISHAVEBREAKFAST
      FROM request_head rh,
           exp_evection_others eeo
     WHERE rh.req_id = eeo.req_id;