Is it possible that when a column is selected from one table that a join is forced to an additional table to limit the data set returned? I know the IN could be used, but for 49 values that would be a massive WHERE clause.

This is in relation to PME 4.5 on Windows with a MySQL db.