DB Join

DB join facilitates reference between tables, from one table to another. Combine rows from two or more tables, based on a common field between them. The concepts below are all based on SQL.

Fields & its description:

Description

Enter the description of the database join operation regarding source and destination.

From

Specify the table from which data has to be retrieved here.

This is the destination table where the data from the source is acquired.

Type

Type may be Direct if the path of data connection is between the source and destination tables only. Indirect type is selected if several tables are accessed in order to connect the source and destination table. If your choice is Indirect then specify the path of "indirect from" and "indirect to" table.

Join

These are table operations where Inner join will retrieve the intersection of data from the source and destination table. Left Outer join will display the common data along with the data from source table.

Expression

This is the expression of the DB join operation.

Contents

Revisions

May 29, 2015 @ 04:03:51 [Current Revision] by vv
May 29, 2015 @ 04:01:08 by vv
May 29, 2015 @ 04:00:37 [Autosave] by vv
May 22, 2015 @ 11:37:39 by vv
May 22, 2015 @ 11:35:44 by vv
May 22, 2015 @ 11:31:50 by vv
May 22, 2015 @ 11:21:48 by vv
May 22, 2015 @ 11:18:30 by vv
May 22, 2015 @ 11:17:17 by vv
May 22, 2015 @ 11:12:23 by vv
May 22, 2015 @ 11:00:37 by vv
May 22, 2015 @ 10:01:07 by vv
May 22, 2015 @ 09:37:10 by vv

Revision Differences

--- May 22, 2015 @ 11:12:23
+++ Current Revision
-Deleted: DB join facilitates reference between databases, from one table to another.
+Added: DB join facilitates reference between tables, from one table to another. Combine rows from two or more tables, based on a common field between them. The concepts below are all based on SQL.
 Unchanged: <a href="http:// help.goodbookserp.com/wp- content/uploads/ 2015/05/dbjo.jpg"><img class="alignnone size-full wp-image-3739" src="http://help.goodbookserp.com/ wp-content/uploads/ 2015/05/dbjo.jpg" alt="dbjo" width="1338" height="367" /></a>
 Unchanged: <strong>Fields &amp; its description:</strong>
 Unchanged: <ul>
 Unchanged:  <li><strong>Description< /strong></li>
 Unchanged: </ul>
 Unchanged: Enter the description of the database join operation regarding source and destination.
 Unchanged: <ul>
 Unchanged:  <li><strong>From< /strong></li>
 Unchanged: </ul>
 Unchanged: Specify the table from which data has to be retrieved here.
 Unchanged: <ul>
 Unchanged:  <li><strong>To< /strong></li>
 Unchanged: </ul>
 Unchanged: This is the destination table where the data from the source is acquired.
+Added: <ul>
+Added:  <li><strong>Type< /strong></li>
+Added: </ul>
+Added: Type may be <em>Direct </em>if the path of data connection is between the source and destination tables only. <em>Indirect </em>type is selected if several tables are accessed in order to connect the source and destination table.
+Added: If your choice is <em>Indirect </em>then specify the path of "indirect from" and "indirect to" table.
+Added: <ul>
+Added:  <li><strong>Join< /strong></li>
+Added: </ul>
+Added: These are table operations where <em>Inner </em>join will retrieve the intersection of data from the source and destination table. <em>Left Outer </em>join will display the common data along with the data from source table.
+Added: <ul>
+Added:  <li><strong>Expression< /strong></li>
+Added: </ul>
+Added: This is the expression of the DB join operation.
 Unchanged: &nbsp;
 Unchanged: &nbsp;
 Unchanged: &nbsp;
 Unchanged: &nbsp;
 Unchanged: &nbsp;
 Unchanged: &nbsp;
 Unchanged: &nbsp;
 Unchanged: &nbsp;

Note: Spaces may be added to comparison text to allow better line wrapping.

Enter your email Address

Revisions

Revision Differences