selecting records from two tables

[junkmail]

I have two tables each having fields a,b,c. What I want to do is select all the records from both tables into one view so if table a has 5 records and table be has 6 records I get a view containing 11 records with only 3 fields being display and not having a,b,c,a,b,c. Seems simple enough but i can't think how to get my result.

 

[bborissov]

What's wrong with UNION ALL?

SELECT A, B, C
       FROM TableA
UNION ALL 
SELECT A, B, C
       FROM TableB

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[junkmail]

Nothing, that worked perfectly. I am fairly new to SQL. Thanks.