I've only used it a few times, but it was usually to combine data from two tables that didn't have a column I could join them on.