subQuery Check is using sourceTable on a through Select

Source table condition on a through subQuery check ( through select with target joined )