User bio
404 bio not found
Member since Sep 30, 2024
Replies:

I'm using DBeaver to access the database and run my queries. I found the issue though; apparently I was missing the error warning, but it was throwing an error on a date field manipulation I was doing, and killing the query at that step.

I'm taking the date of birth then using that to get the first day of the month they were born in, and the last day of the month they were born in plus different numbers of years. To make some age ranges. Apparently some of the records didn't of a date of birth, so when it hit that it errored out on my field to manipulate the date. So I had to put in a CASE statement to catch if the field was NULL and now the query is returning all results.

That explains why replace the select statement with just the COUNT(*) worked, since it removed that date field manipulation that was giving the problem.

Issue is resolved.

Certifications & Credly badges:
Robert has no Certifications & Credly badges yet.
Global Masters badges:
Robert has no Global Masters badges yet.
Followers:
Robert has no followers yet.
Following:
Robert has not followed anybody yet.