I am doing a simple query of a table of student's particulars. I'm just doing a very simple query of <First Name> and <Last Name>.
However, many of the records are not showing up. E.g. there are 159 records in the student table, but in the query, only 34 records are showing up. I have not set any kind of criteria or filtering in my query.
How do I troubleshoot this so I know why they're not showing up? Thanks.