Can I also create a sql view rather than just having the ability to pull out data from one table in database emulation?? I would like to have the rows returned based on certain joins in the database. Is it possible?

Thanks!