You use relationships to connect tables by fields that they have in common.A table can be part of any number of relationships, but each relationship always has exactly two tables.Conceptually, a join is very similar to a table relationship.
![]() Select tblProjects and tblTasks and close the Show Table dialog box as in the following screenshot. A couple of these projects have a lot of tasks associated with that project and this information is related through ProjectID field. Let us select the second option, which is Left Outer Join, and click Ok. When you run this query, you will see the following results. All of this will be blank because there is no related information in tblTasks, where these fields come from. Let us now go to the Design View again and double-click on the relationship line. You will see that a little arrow is now pointing towards ProjectID in tblProjects. ![]() For example, look at the employees table with a supervisor field, which references the same kind of number stored in another field within the same table the employee ID. To do that, we need to open the show table dialog box and add tblEmployees one more time. To do that, click on Supervisor in tblEmployees table and hold the mouse button and drop it right on top of the EmployeeID in that copied table tblEmployees1. Then, add the first name and last name from that copied table. And, this is how you create a Self-join in Microsoft Access.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |