Join Tables from multi aliases using SQL

I hv a no. of aliases (because the files are classified into different
directories, eg. parameter, data) and I would like to join them by using
the SQL. But I don't know how to do this.  Would anyone can help me?

Thanks a lot!