Home Forums SQL Server 7,2000 T-SQL Union vs. Join RE: Union vs. Join
Andy Jones, DBA
Hall of Fame
Points: 3641
More actions
December 4, 2002 at 8:07 am
#443093
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
.