
Simple Definitions for Joins
Inner Join - returns only those rows from the left table where they have a matching row in the right table based upon the join criteria.
Left Join- returns all rows from the left table even if there are no matching rows where found in the right table. Any values selected out of the right table will be null for those rows where no matching row is found on the right table. Left Joins tend to be more portable and easier to read
Right Join- Same as a left join, but from opposite direction. This will return all rows in the right table regardless of matching rows in the left table.
No comments:
Post a Comment