re: combine data from two tables

2002-12-14 Thread Egor Egorov
On Thursday 12 December 2002 20:35, Mark Goodge wrote: > I'm hoping that someone can give me some pointers on this problem. I have > two tables that contain similar data (eg, people.employees and > people.volunteers). I need to run a select statement to retrieve names from > both tables, and then

combine data from two tables

2002-12-12 Thread Mark Goodge
Hi, I'm hoping that someone can give me some pointers on this problem. I have two tables that contain similar data (eg, people.employees and people.volunteers). I need to run a select statement to retrieve names from both tables, and then display the data sorted by name so that it doesn't matt