If the query contains complex definitions (e.g. multiple joins and conditions), what object should you create?A.Temporary join tableB.ViewC.Either of the two

You should create a View. A View is a virtual table based on the result-set of an SQL statement. It contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

By using a View, you can simplify complex queries (like ones with multiple joins and conditions) into a single table. This not only makes your SQL code cleaner and easier to read, but it also encapsulates the complexity of the underlying data.

However, depending on the specific requirements and the database system you are using, a temporary join table could also be a viable solution. This is a physical table that stores the result of a complex query and can be used in subsequent queries.

So, the answer could be either B. View or C. Either of the two, depending on the specific circumstances.