Filter Data for clustering
If you can afford to do the full join once, do it and learn which columns are useful through feature selection. Then you can only SELECT these columns for subsequent iterations, when the database is updated.

Here's a survey: Feature Selection for Clustering: A Review