查询过滤 [英] query filtering

问题描述

我有一个幼儿园数据库，当然还有父母和孩子。有些情况下，父母在那里的孩子很少。

我建立了一个查询，其中包括我发送图片等的姓名和电子邮件''。


问题：孩子很少的父母收到的电子邮件很少。

问题：如何过滤同一个孩子的父母只能收到1封电子邮件的查询？


谢谢。

解决方案

轻松完成。

如果我们知道桌子就容易多了虽然布局。


您可以简单地使用SELECT子句的DISTINCT谓词。发布你的信息，我们可以为你整理一下。

我不知道SQL，但这里是我查询的sql基础：

SELECT TBL_NEW_CHILDREN.FAMILY_ID，[FAMILY]& "，" &安培; " " &安培; [MOTHER_name] AS名称，TBL_NEW_FAMILY。[E-MAIL]，TBL_NEW_CHILDREN.FIRST_NAME，TBL_NEW_CHILDREN.STATUS

来自TBL_NEW_FAMILY INNER JOIN TBL_NEW_CHILDREN ON TBL_NEW_FAMILY.ID_FAMILY = TBL_NEW_CHILDREN.FAMILY_ID

WHERE（（（TBL_NEW_FAMILY。[E-MAIL]）不为空）AND（（TBL_NEW_CHILDREN.STATUS）=有效））;

感谢您的帮助。

首先，让我们整理SQL，这样它就不是一个完整的一塌糊涂。 SQL在任何形式下都可以正常工作，但是使用SQL可能会非常混乱，除非你对它施加一些结构（与其他人共享它当然不建议以那种形式）。

展开 | 选择 | Wrap | 行号

I have a database of kindergarten in which there are parents and children of course. There are cases where a parent has few kids there.
I built a query which colects the names and e-mails where I send them pictures etc''.

The problem : parents with few kids are getting few of the same e-mails.
Question : how do I filter the query that the same parent of few kids will get only 1 e-mail please?

Thanks.

解决方案

Easily done.
Much easier if we know the table layout though.

You can probably simply use the DISTINCT predicate of the SELECT clause. Post your info and we can tidy it up a bit for you.

I don''t know SQL but here''s the sql basis of my query :

SELECT TBL_NEW_CHILDREN.FAMILY_ID, [FAMILY] & "," & " " & [MOTHER_name] AS name, TBL_NEW_FAMILY.[E-MAIL], TBL_NEW_CHILDREN.FIRST_NAME, TBL_NEW_CHILDREN.STATUS
FROM TBL_NEW_FAMILY INNER JOIN TBL_NEW_CHILDREN ON TBL_NEW_FAMILY.ID_FAMILY = TBL_NEW_CHILDREN.FAMILY_ID
WHERE (((TBL_NEW_FAMILY.[E-MAIL]) Is Not Null) AND ((TBL_NEW_CHILDREN.STATUS)="active"));

Thanks for your help.

First, let''s tidy up the SQL so it''s not a complete mess. SQL works fine in any form, but working WITH SQL can be very messy unless you impose some structure on it (Sharing it with others is certainly not to be recommended in that form).

Expand|Select|Wrap|Line Numbers

这篇关于查询过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！