SELECT
DISTINCT q.id,
q.employee_name AS employeeName,
q.employee_id AS employeeId,
t.sex AS sex,
e.weight AS weight,
e.height AS height,
t.birthday AS birthday,
b.qualification AS education,
t.join_member_time AS joinMemberTime,
t.department AS crew,
w.squadron AS squadron,
d.qualification_name AS qualificationName,
a.serve_type AS serviceModel,
c.visa_type AS visaInformation,
q.speciality AS speciality,
q.competition_experience AS performanceCompetitionExperience,
q.etiquette_experience AS etiquetteExperience,
q.picture AS pictures,
q.family_background AS familyBackground,
q.recommendations AS recommendations,
q.video AS video,
q.talent_certificate AS talentCertificates
FROM
ct_bit q
LEFT JOIN (SELECT * FROM hr_base_info WHERE delete_flag = 0) t ON q.employee_i
左连接查询的SQL
最新推荐文章于 2023-11-15 16:26:58 发布