本文介绍了如何为我的要求编写SQL查询。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有两张桌子,学生和费用。学生表包含学生相关数据和费用表包含学生的费用记录。



实际上,我的问题是我想展示那些没有支付这个月费用的违纪学生。



Sol。在我看来是:

我想首先从学生表中搜索所有学生,然后查询应在费用表中搜索尚未支付本年度当月费用的学生。\



我的问题是如何根据我的上述要求编写查询。

I have two tables, Students and Fees. Students table contains Student Related Data and Fees table contains Fee record of Students.

Actually, My problem is i want to show defaulter students who have not paid this month fee.

Sol. seems to me is :
I want to search all Students first from Students table, then query should search in Fee table for students who have not paid their fee of this month of Current Year..\

My Question is How to write query for my above requirement.

推荐答案



这篇关于如何为我的要求编写SQL查询。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-26 06:02
查看更多