reset password
Author Message
msargent
Posts: 519
Posted 19:40 Nov 02, 2011 |

Can you use a left join when an inner join will work? Should you use left joins only when needed?

cysun
Posts: 2935
Posted 22:26 Nov 02, 2011 |

Left join basically gives you the results of an inner join plus the unmatched rows. You should only use left join when needed because otherwise your results may contain unwanted rows.