Record from multiple tables can not be retrieve using query?
Answers
Answered by
6
Build a select query by using tables with a many-to-many relationship
On the Create tab, in the Queries group, click Query Design. ...
In the Show Table dialog box, double-click the two tables that contain the data you want to include in your query and also the junction table that links them, and then click Close.
On the Create tab, in the Queries group, click Query Design. ...
In the Show Table dialog box, double-click the two tables that contain the data you want to include in your query and also the junction table that links them, and then click Close.
Answered by
0
In SQL, to fetch data from multiple tables, the join operator is used. The join operator adds or removes rows in the virtual table that is used by SQL server to process data before the other steps of the query consume the data
Explanation:
Similar questions