學生資料 能否以SQL查詢全校跨境生清單？

如題，是否可以簡單得出全部跨境生的基本資料？

 

老師可以試試以下SQL

select
a.CLASSCODE as '班別',
a.CLASSNO as '班號',
a.CHNAME as '姓名',
a.ENNAME as '英文姓名',
a.SEX as' 性別',
dateformat(a.DOB, 'YYYY/MM/DD') as '出生日期',
a.REGNO as'註冊編號',
a.STRN '學生編號',
c.CHNAME as '監護人中文姓名',
c.EMERGENCYPHONE 'Guardian Emergency No.',
b.CH_DES'區議會分區'


from VW_STU_LATESTSTUDENT a

left outer join TB_HSE_COMMON b on
b.CODE_ID=a. DISTRICTCOUNCIL and b.TB_ID='HOMEDB' and b.SUID=a.SUID

left outer join TB_STU_PARENT c on
c.STUID = a.STUID and c.GUARDIANIND='1' and c.SUID = a.SUID

where a.SCHYEAR = ? and b.ch_des = '中國內地'

order by a.CLASSCODE, a.CLASSNO