Combine Queries
 
 
 

To use Link Select

  1. In the dbConnect Manager, in the tree view, right-click a link template. Click Link Select.
  2. Select the Select option from the Do list.
  3. Select a link template from Using.
  4. Select one of the following options:
  5. Click either Execute or Select to add your query or graphical object selection set to the Link Select operation.
  6. Select a Link Select operation from the Do list: Union, Intersect, Subtract A-B, or Subtract B-A.
  7. Repeat steps 3 through 5 to add set B to the Link Select operation.
  8. Select one or both of the following options and click Finish to complete the Link Select operation:
NoteIt is recommended that you turn off the Indicate Records in Data View option if you are performing a Link Select operation on links from more than one database table. Link Select only displays records from the table that the current link template references. This limitation can cause misleading results to be returned to the Data View window.