美文网首页
Mysql 多表Left join 查询_crazydiy_

Mysql 多表Left join 查询_crazydiy_

作者: 安晓生 | 来源:发表于2020-03-30 13:16 被阅读0次

    基础多表查询

    两个表这间的查询
    
    SELECT c.serial,c.otherserial,c.os_license_id asdate,u.name,u.firstname,u.realname from glpi_computers as c leftjoin glpi_users as u on c.FK_users=u.id
    
    三个表之间的查询
    
    SELECT c.serial,c.otherserial,c.os_license_id asdate,u.name,u.firstname,u.realname,s.name from (glpi_computers as cleft join glpi_users as u on c.FK_users=u.id) left joinglpi_dropdown_state as s on c.state=s.id
    
    多个表之间的查询
    
    SELECT c.serial as Serial_Number,c.otherserial asFA_Number,c.os_license_id as Buy_Date, l.completename asLocation,d.name as Section,m.name as Model,t.name as PC_Type,u.nameas GID,u.firstname as FirstName,u.realname as LastName,s.name asStatus
    from (((((glpi_computers as c left join glpi_dropdown_domain as don c.domain=d.id) left join glpi_dropdown_model as m onc.model=m.id) left join glpi_dropdown_state as s on c.state=s.id)left join glpi_type_computers as t on c.type=t.id) left joinglpi_users as u on c.FK_users=u.id) left joinglpi_dropdown_locations as l on c.location=l.id
    
    
    SELECT c.serial as Serial_Number,c.otherserial asFA_Number,c.os_license_id as Buy_Date,l.completename asLocation,d.name as Section,m.name as Model,t.name as PC_Type,u.nameas GID,u.firstname as FirstName,u.realname as LastName,s.name asStatus
    from (((((glpi_computers as c left join glpi_dropdown_domain as don c.domain=d.id) left join glpi_dropdown_model as m onc.model=m.id) left join glpi_dropdown_state as s on c.state=s.id)left join
    glpi_type_computers as t on c.type=t.id) left join glpi_users as uon c.FK_users=u.id) left join glpi_dropdown_locations as l onc.location=l.id
    
    
    SELECT t.name as issue,c.completename as category,t.date asopendate,t.closedate,t.status FROM glpi_tracking t,glpi_dropdown_tracking_category c where t.category=c.id andc.completename like 'IT%' and t.date >'2011-07-31'and t.closedate <'2011-09-01'
    

    相关文章

      网友评论

          本文标题:Mysql 多表Left join 查询_crazydiy_

          本文链接:https://www.haomeiwen.com/subject/dwxvuhtx.html