我需要对两个表进行比较的查询示例代码 [英] I need to sample code of query which compare two table

问题描述

我需要从成员表中选择一些信息，其中member field = familymember field

I need to select some information from member table where member field =familymember field

推荐答案

表的含义是什么?如果您的意思是数据库表，我建议这正是一种琐碎，简单，愚蠢的证明任务，您应该对此进行一些研究，并以此为至少学习数据库开发基础知识的机会.

我想您正是想要这种建议，而不是您可以复制和粘贴的代码，因为否则您会告诉我们表的架构以及编写此代码所需的其他信息.

What do you mean by table ? If you mean a database table, I would suggest that this is precisely the sort of trivial, simple, idiot proof task that you should do some research on and use as an opportunity to learn at least the basics of database development.

I assume you wanted precisely this sort of advice and not code you could copy and paste, because otherwise you''d have told us the schema of your tables and the other information required to write this code.

你好，
请再详细说明您的问题.

Hello,
Plz, elaborate your question a bit.

您好，

您可以根据自己的要求尝试类似的代码:

选择*
来自员工，部门
WHERE employee.DepartmentID =部门.DepartmentID

希望这会有所帮助.

Hello,

You may try similar code according to your requirement:

SELECT *
FROM employee, department
WHERE employee.DepartmentID = department.DepartmentID

Hope this will be helpful.

这篇关于我需要对两个表进行比较的查询示例代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！