Tuesday, December 12

Other Join Types

Google+ Pinterest LinkedIn Tumblr +

Now that you know about the difference between the default join type when using a Database File connection versus a SQL or ODBG connection, you need to know that-when using connections from the ODBC list you can change the join type. You cannot change the join type when using a Database File connection.

By default, ODBC uses an equal join. SCR gives you the ability to change this to a left outer join. And, though less popular, you can also use the opposite: the right outer join. If you use a right outer join, the report prints all the records from the right-hand table, and only matching records from the left-hand table.

Back to Free Credit Bank. If you link the Cardholder table to the Purchases table using a right outer join, your report would have every purchase made from the Purchases table, and a matching Cardholder record. If a cardholder did not have any purchases, that Cardholder record would not print. However, if for some reason a record existed in the Purchases table without a related Cardholder record that Purchases record would still print on the report. Other join types include:

·         Greater

·         Less

·         Greater or Equal

·         Less or Equal

·         Not Equal

To change the join type of “an existing link:

1.        In the Visual Linking Expert, select the link you want to change. Click. the Link Options button, or right-click the link and choose Optionthe Link Options dialog box opens.

2. In the SQL Join Type area, select a different join type, and then click OK

You can also manipulate the arrangement of tables in the Visual LinkingExpert to change the join types. The important thing to remember is which table you linked “from” and which “to” so that it is easier if you start changing the join types.

Share.

About Author

Leave A Reply