[RESOLVED] Left Join vs Inner Join

[obrienkev]

Hi all,

Whats the difference between Left Join and Inner Join?

Thanks.

Kevin.

[Roger_Ramjet]

An inner join returns the set of records that have an entry in BOTH tables.

A left join returns the set of records from the first (left) table that match your selection criteria irrespective of there being a corresponding records in the second (right) table. It also returns any corresponding record from the right table and NULL when there is no match.

[obrienkev]

Thank you! 🙂