If you want to join you need to have an ID field on which you will be joining.
Load * from QVD1.qvd(QVD);
left join (Table1)
Load * from QVD2..qvd(QVD);
If you just want to concatenate make sure you have the field names same or at least 80% same for performance sake and use 'concatenate' key word.