You can use table-valued objects in queries or views. These objects can hold information from many different tables and can therefore reduce the number of tables you must use in a query. A table-valued object can be a table, a view, a function, a synonym, or a local table. You can see table-valued objects in the Query Designer's Diagram pane when you open a view or create a query.
You can use a view, synonym, or local table just as you would a table. When you use a table-valued function you'll need to assign a value to its parameters before you can run the query. To do this, select the table-valued function in the Diagram pane, and then in the Properties window click the ellipses (…) beside Parameter List.