what are created using both tables and query
Answers
Answer:
To create a multi-table query: Select the Query Design command from the Create tab on the Ribbon. In the dialog box that appears, select each table you want to include in your query and click Add.
Type FROM, followed by the name of the first of the tables you want in the query. ... Type UNION, and then press ENTER. Type SELECT, followed by a list of the fields from the second table you want in the query. You should include the same fields from this table that you included from the first table, and in the same order.
The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. In Oracle, the table has a single VARCHAR2(1) column called DUMMY that has a value of 'X'. It is suitable for use in selecting a pseudo column such as SYSDATE or USER.
hope it is helpful
make me as brineliest
Answer:
Use the Query Wizard to build a query from a primary table and a related table
Ensure that the tables have a defined relationship in the Relationships window.
How?
On the Database Tools tab, in the Show/Hide group, click Relationships.
On the Design tab, in the Relationships group, click All Relationships.
Identify the tables that should have a defined relationship.
If the tables are visible in the Relationships window, check to see that a relationship has already been defined.
A relationship appears as a line connecting the two tables on a common field. You can double-click a relationship line to see which fields in the tables are connected by the relationship.
If the tables are not visible in the Relationships window, you must add them.
On the Design tab, in the Show/Hide group, click Table Names.
Double-click each of the tables you want to show, and then click Close.
If you do not find a relationship between the two tables, create one by dragging a field from one of the tables to a field on the other table. The fields on which you create the relationship between the tables must have identical data types.
Note: You can create a relationship between a field that is of the AutoNumber data type and a field that is of the Number data type, if that field has a long integer field size. This will often be the case when you are creating a one-to-many relationship.
The Edit Relationships dialog box appears.
Click Create to create the relationship.
For more information about the options you have when you create a relationship, see the article Create, edit or delete a relationship.
Close the Relationships window.
On the Create tab, in the Queries group, click Query Wizard.
In the New Query dialog box, click Simple Query Wizard, and then click OK.
In the Tables/Queries combo box, click the table that contains the basic information you want included in your query.
In the Available Fields list, click the first field you want to include in your query, and then click the single right arrow button to move that field to the Selected Fields list. Do the same with each additional field from that table that you want to include in your query. These can be fields that you want returned in the query output, or fields that you want to use to limit the rows in the output by applying criteria.
In the Tables/Queries combo box, click the table that contains the related data you want to use to enhance your query results.
Add the fields that you want to use to enhance your query results to the Selected Fields list and then click Next.
Under Would you like a detail or summary query?, click either Detail or Summary.
If you do not want your query to perform any aggregate functions (Sum, Avg, Min, Max, Count, StDev, or Var), choose a detail query. If you do want your query to perform an aggregate function, choose a summary query. After you make your choice, click Next.
Click Finish to view the results.
Explanation:
hope it helps you ..