hello sir
how to display the data of students who have not made a monthly fee???
now I can only show the data that has been doing a monthly fee, all I want is how to select it, in order to display the data of students who have not made the monthly dues
This invoice table
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[invoice](
[invoiceID] [int] IDENTITY(10000,1) NOT NULL,
[invoiceDate] [datetime] NULL,
[studentID] [varchar](16) NULL,
[paidDate] [date] NULL,
[description] [varchar](255) NULL,
[amount] [money] NULL,
[state] [tinyint] NULL,
[createdBy] [varchar](16) NOT NULL,
[createdDate] [datetime] NOT NULL,
[updatedBy] [varchar](16) NULL,
[updatedDate] [datetime] NULL,
CONSTRAINT [PK_invoice] PRIMARY KEY CLUSTERED
(
[invoiceID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON ...
Go to the complete details ...