I am writing a SQL 2005 Query and am having difficulty seeing contents of two tables with similar information. The two tables I am working with have the same columns (labeled the same). One table is for open orders and the other is for closed orders. I am trying to write a query that will show all of the orders at the same time.
I know I can have a column with alias 'Order Number Open' and a column called 'Order Number Closed' but I want to see all of the order numbers in the same 'Order Number' Column.
Is this a function of JOIN? Or maybe I need to make a view? (I don't know how to make views with Management Studio 2005)
Thanks for all your help experts!