Can I add 'with (NoExpand)' after the select and before the where?

Not familiar (yet) with NoExpand, but can you either change the SQL view or create a new SQL view with NoExpand? On the Clarion side, it then simply becomes another table.