yes, you can run regular sql queries on your database where you can join/group tables.

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.