问题描述
我有一个结算数据库，用于每六个月向客户收费。所有客户都会同时收费。我想做一份报告，告诉我客户是否在一段时间内没有账单。我有tblInvoices和tblCustomer。我需要遍历每个客户，看看它是否在指定的结算周期内的tblInvoices中匹配。我该怎么做呢？我猜它是一个查询，但不像我曾经创建的那个。 tblInvoices和tblCustomer使用两个表中的CustomerID字段相关联，其中InvoiceID是tblInvoices的PK，而CustomerID是tblCustomer的PK。
I have a billing database that is used to bill customers every six months. All customers are billed at the same time. I would like to make a report that tells me if a customer didn''t have a bill for a certain period. I have tblInvoices and tblCustomer. I need to run through every customer to see if it has a match in the tblInvoices for a specified billing period. How do I do this? I''m guessing that it is a query, but not like one that I''ve ever created. tblInvoices and tblCustomer are related using the CustomerID fields in both tables with InvoiceID being the PK for tblInvoices and CustomerID being the PK for tblCustomer.
推荐答案
这篇关于我如何找到本月没有收费的客户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！