Posted by Eswar Koneti on August 30th, 2012
Joins ? In Simple terms they are used to Join more than 2 tables and give you required information.
while working with SCCM reports,we will use SQL Joins in most of the reports to get customized information (not part of default reports).
These joins are used to query data from two or more tables, based on a relationship between certain columns in these tables. It creates a set that can be saved as a table or used as is.
JOIN is a means for combining fields from two tables by using values common to each. ANSI standard SQL specifies four types of
Here is nice Pictorial representation of using SQL Joins.You can keep it as reference when creating reports/collections on the need basis.
INNER JOIN : This Join used to get result when there is at least one match in both tables.
LEFT JOIN :This Join used to get all rows from the left table even if there are no matches in the right table.
RIGHT JOIN : This Join used to get all the rows from the right table, even if there are no matches in the left table
Full Join : This Join used to get all rows when there is a match in one of the tables.