What is the Difference Between Left Joins and Inner Joins in SalesLogix?

Question:

What is the difference between Left joins and Inner joins in SalesLogix?

Answer:

Inner
and left denotes the type of joins between tables.  If you have an inner
join then a record must exist in both tables in order for results to be
returned.  If it is a left join then all rows from the parent table will
be returned even if there is not a matching record in the other table.

 

Select
Account inner join accountsummary on account.accountid=accountsummary.accountid

returns
only records where a matching Accountid record exists in both the account and
account summary table

 

Select
Account left join accountsummary on account.accountid=accountsummary.accountid

returns all account records even if the
accountsummary table does not have a matching accountid in it.

 

Want content like this delivered to your inbox? Sign up for our newsletter!

Submit a Comment

Your email address will not be published. Required fields are marked *