Help Creating a View

[mattv10]

Hi,

I want to create a view of two tables. However, my two tables are very similar in the data they have; there are differences though. I don't want it to paste all the similar data twice though I want it to merge the similar data.. Is this what a view does anyway???

Thanks in advance!

 

[mattv10]

I've figured it out for anyone who is interested. I did a UNION Query.