使用JOIN基于ID从另一个表中获取名称 [英] Get name from another table based on ID using JOIN

问题描述

您好，



我一直在处理有关LEFT JOINING的问题，其中有一个表格，显示我提到的Projects数据。但是项目是从另一个表中选择的。

原始输出显示的是project_ID而不是项目名称本身。怎么办呢？

这是主表的输出：



ID |项目| （...）|

---------------------

1 | 3 | （...）|

---------------------



项目表输出：



ID_PROJECT | NAME |有效|

---------------------------

1 |测试| 0 |

2 | TEST2 | 1 |

3 | GLOSS | 1 |

---------------------------



我想要的是能够获得如下输出：



ID |项目| （...）|

---------------------

1 |歌词| （...）|

---------------------



我尝试了什么：



这是关于这个项目的MySQL查询：

Hello,

I've been dealing with a problem regarding LEFT JOINING where I have a table that shows me data referred to `Projects`. But the projects are chosen from another table.
The original outputs are showing me project_ID instead of the project name itself. How can this be done?
This is the output from the primary table:

ID | Project | (...)|
---------------------
1 | 3 | (...)|
---------------------

Projects Table output:

ID_PROJECT | NAME | VALID |
---------------------------
1 | Test | 0 |
2 | Test2| 1 |
3 | GLOSS| 1 |
---------------------------

What I want is to be able to get the output like so:

ID | PROJECT | (...)|
---------------------
1 | GLOSS | (...)|
---------------------

What I have tried:

This is my MySQL query regarding this project:

SELECT ID, PROJECT As `Project Name` FROM zestagio.dv_principal AS C LEFT JOIN zestagio.dv_project AS B ON C.project=B.id_project

推荐答案

SELECT p.ID, s.[Name] AS [Project] FROM zestagio.dv_principal p
JOIN zestagio.dv_project s ON p.Project = s.ID_PROJECT

这篇关于使用JOIN基于ID从另一个表中获取名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！