Show the budget type code and description and the corresponding document id.
create table ref_budget_codes (budget_type_code varchar, budget_type_description varchar, PRIMARY KEY (budget_type_code)); create table documents_with_expenses (document_id varchar, budget_type_code varchar, PRIMARY KEY (document_id))
select t2.budget_type_code, t2.budget_type_description, t1.document_id from documents_with_expenses as t1 join ref_budget_codes as t2 on t1.budget_type_code = t2.budget_type_code