prelim where clauses while joining