What is the day Number and date of all the documents?
create table all_documents (date_stored varchar, date_stored varchar, PRIMARY KEY (date_stored)); create table ref_calendar (day_number varchar, calendar_date varchar, PRIMARY KEY (day_number))
select t2.day_number, t1.date_stored from all_documents as t1 join ref_calendar as t2 on t1.date_stored = t2.calendar_date