mysql联表查询

select a.name,a.quota_mailbox,a.quota_netdisk,a.limit_send,a.limit_recv,b.realname,c.dept_id,c.position,d.title from core_mailbox a,co_user b,co_department_member c,co_department d where a.mailbox_id=b.mailbox_id and a.mailbox_id=c.mailbox_id and c.dept_id=d.id;

mysql联表查询

标签：mysql联表查询