Extremely new at SQL, I'm in a class right now and I am not sure what I am doing wrong. I am supposed to write several statements using JOIN and BETWEEN, my statements look good and execute properly but for some reason not all the data is returning for example.
Here is an example of the insert statement I am using
and here is the sample of one of the searches I'm trying to do.
SELECT Employee.Last_name, Employee.First_name, Employee.Job_title, Job_title.EEO_1_Classification, Employee.Wage
FROM Employee JOIN job_title ON Employee.job_title = Job_title.Job_title WHERE Wage BETWEEN 15000.00 and 51000.00
It should bring back about 12 hits but it is only bringing back 4 and I'm not sure why.