Joining tables

To join tables, create a link between an object in each of the tables.

  1. In the Query Builder window, open at least two tables.

  2. In the first table, select the field that you want to link and drag it to the corresponding field of the other object.

    image67.jpg
     

  3. After you finish dragging, a line connecting the linked fields appears.

    image24.jpg

    The default join type is INNER JOIN; only matching records of both tables will be included in the resulting dataset.
     

  4. To define other types of joins, right click the link and select Edit... or double-click the link.


    image68.jpg

     

  5. The Link Properties dialog box appears.

    image33.gif

    Using Link Properties, you can define join type and other link properties.
     

  6. To remove a link between objects, right-click the link line and select Remove.