What is the document type name and the document type description and creation date for all the documents?
create table ref_document_types (document_type_name varchar, document_type_description varchar, document_type_code varchar, PRIMARY KEY (document_type_name)); create table documents (document_date varchar, document_type_code varchar, PRIMARY KEY (document_date))
select t1.document_type_name, t1.document_type_description, t2.document_date from ref_document_types as t1 join documents as t2 on t1.document_type_code = t2.document_type_code