I'm not the SQL expert, so any others that want to comment, please feel free.
The short answer is that, for SQL, you'd set the "owner" string for each table in the same place.
As I understand it, Clarion doesn't like being connected to 2 different databases at the same time. But I'm a little fuzzy on this bit.
If that is the case then I would suggest using variable table names, and so keeping the data all in one "database" but in separate "tables".