Posted on: 11/2/2012 3:31:30 AM | Views : 304

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 ...