select a.userid,a.userpw,b.name,b.mailaccept,b.email,b.company,b.company,b.department,b.homepage,


              ------>left(b.id_number,6)<---------------


,b.birthday,b.gender,b.telno,b.hpno,b.zipcode,b.addr1,b.addr2,b.com_zipcode,b.com_addr1,b.com_addr2,b.job,


b.marriage,b.marriageday,b.regist_date from t_member as a inner join t_user_member as b on 


a.member_idx=b.member_idx and a.userid='1' 




원하는 값은 나오는데 qa에서 실행하면 화살표부분은 열이름이없다고 나옴니다 열이름이 나오도록 하는 방


법은 없을까요?

left(b.id_number,6) as left_id_number  라고 임의로 컬럼명을 지정하시면 됩니다.