StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POQuery malfunction in SQLServerCE using with VB.NET
text
Body
copied!<p>I am working on a project, where my target is to automate the fee-system of a school. I am implementing the project in VB.NET 2012 and using SQLServerCE for handling data.</p> <p>My situation is like this :</p> <p>I have two tables namely : 'feecollection' and 'StudentDetails'</p> <p>The columns of the table feecollection are as follows <img src="https://i.stack.imgur.com/4Bf0g.png" alt="feecollection"></p> <p>Similarly, the columns of the table StudentDetails are as follows <img src="https://i.stack.imgur.com/u0j5Z.png" alt="StudentDetails"></p> <p>Now I want to find out the names of student(s) who are defaulters. I am doing the filtering on the basis of Name, Months and the defaulter fields.</p> <p>Logic : The name of the students who are in fee collection for a given month have paid, so defaults are all names which are in StudentDetails but not in feecollection whose defaulter field is '1' (1 indicates that they have paid).</p> <p>My query : </p> <pre class="lang-sql prettyprint-override"><code>select StudentDetails.Name where StudentDetails.Name not in (Select feecollection.Name, feecollection.Month, feecollection.defaulter, StudentDetails.Name from feecollection inner join StudentDetails on feecollection.Name = StudentDetails.Name where StudentDetails.Name = 'def' and feecollection.month = 'January' and feecollection.defaulter = '1' </code></pre> <p>But this query is not working properly. Where did I go wrong on this ?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload