时间戳

首页 > 解决方案 > 使用左连接时如何在查询结果中不包含 ID

mysql - 使用左连接时如何在查询结果中不包含 ID

问题描述

我试图用三个表中的数据填充我的列表视图，stu_tblbasicinfo它们 都有相同的 id，即stu_tblfamstu_tbleducbackgroundTagID

Select A.TagID , A.Surname, A.Firstname, A.Middlename, A.Course, A.Year, B.ZipCode,
    B.Province, B.Municipality, B.Barangay, A.ContactNo, A.EmailAddress, A.Birthdate,
    A.Age, A.Birthplace, A.Religion, A.Gender, A.CivilStatus, A.Spouse, C.Mothersname,
    C.M_occupation, C.M_Number, C.Fathersname, C.F_Occupation, C.F_Number,
    C.GuardianName, C.G_Occupation, C.G_Number, D.Elementary, D.E_Years, D.JuniorHigh,
    D.J_Years, Seniorhigh, D.S_Years
from stu_tblbasicinfo As A
left join stu_tblzipcode As B
    on A.Barangay = B.Barangay
inner join stu_tblfam As C
    ON A.TagID = C.TagID
inner join stu_tbleducbackground As D
    ON A.TagID = D.TagID

我的代码有效，但问题是它显示 3 TagID。

结果是这样的 TagID(studentinfo table),Surname,Firstname,Middlename,TagID(familyBackground table),MName,FName,Gname,TagID(EducBackground table),Elementary,E_years,JuniorHigh,J_Years,SeniorHigh,S_Years

我怎样才能以这种格式制作结果？ TagID,Surname,Firstname,Middlename,Mname,Fname,Gname,Elementary,E.Years,JuniorHigh,J_Years,SeniorHigh,S_Years

标签： mysqlvb.net

解决方案

只是这个：

  Select 
    A.TagID , 
    A.Surname, 
    A.Firstname, 
    A.Middlename,
    C.Mothersname,
    C.Fathersname, 
    C.GuardianName, 
    D.Elementary, 
    D.E_Years, 
    D.JuniorHigh,
    D.J_Years, 
    D.Seniorhigh,
    D.S_Years 
        from stu_tblbasicinfo As A
        left join stu_tblzipcode As B
            on A.Barangay = B.Barangay
        inner join stu_tblfam As C
            ON A.TagID = C.TagID
        inner join stu_tbleducbackground As D
            ON A.TagID = D.TagID

推荐阅读