JPFred
Registered User.
- Local time
- Today, 13:11
- Joined
- Oct 29, 2017
- Messages
- 47
I have written an sql query (below) and need to have a user friendly column heading displayed with each field. I a retired senior programmer analyst and have been retired for 10 years. I know there is something I have forgot to accomplish my issue. Any help will be appreciated.
Code:
SELECT accession, spineselect, deweynum, checkedoutby, gradelevel, title, checkedoutdate, duedate, gradelevel
FROM main
WHERE duedate < date() and late = "Yes"
ORDER BY gradelevel, checkedoutby, duedate;