• Joins are to return data from 2 or more related tables e.g.

    select * from customers c inner join orders o on c.id=o.id

    Union is to return multiple result sets of the the same structure as one e.g. select 1 union select 2.

    Regards,

    Andy Jones

    .