if you want to join/group static files (like csv/excel), then you'd need import your files into dropbase DB first and then run sql query on that DB.
let me know if this answered your questions.