Home >Backend Development >PHP Tutorial > MYSQL 这个多表查询语句该如何写

MYSQL 这个多表查询语句该如何写

WBOY
WBOYOriginal
2016-06-13 12:46:56874browse

MYSQL 这个多表查询语句该怎么写
有下面两张表
部门表A

入库表B

我现在想把入库表中的into_dpID 字段和部门表中ID字段一样的查出来并且结果是要显示dpName 这个字段的值

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn