I have to solve this problem as quickly as possible but i am a newbie to `Transact-SQL`.

I have a view `vStockSerialsTemp`:

```
  Serial StockCode ActionPrice  StockName      Warehouse   ActionType
    123    P-0304    350          Galaxy S4      Centeral    Income
    456    P-0305    450          Iphone 5s      Centeral    Income
    567    P-0305    450          Iphone 5s      Centeral    Income
    123    P-0304    350          Galaxy S4      Centeral    Expense
    235    P-0304    350          Galaxy S4      Centeral    Income
    567    P-0305    450          Iphone 5s      Centeral    Expense

```

So, based on this view, I have to create a new View that will count the balance of each stock with the same Serials. We subtract rows with ActionType
Expense from ActionType Income with identical Serials. Thus the view should look like:

```
 Serial StockCode ActionPrice  StockName      Warehouse   ActionType
    123    P-0304    350          Galaxy S4      Centeral    Income
    456    P-0305    450          Iphone 5s      Centeral    Income
    567    P-0305    450          Iphone 5s      Centeral    Income
    123    P-0304    350          Galaxy S4      Centeral    Expense
    235    P-0304    350          Galaxy S4      Centeral    Income
    567    P-0305    450          Iphone 5s      Centeral    Expense
    -----------------------------------------------------------------
    456    P-0305    450          Iphone 5s      Centeral    Balance
    235    P-0304    350          Galaxy S4      Centeral    Balance

CREATE vStockSerials as 
SELECT * FROM [dbo].[dbo.vStockSerialsTemp]
UNION 
// Here is the problem indeed

```

How can I select rows from `vStockSerialsTemp` here?