SELECT ;
     IIF( ISNULL(Inward.Itemcode), Outward.Itemcode, Inward.Itemcode) AS Itmecode, ;
     IIF( ISNULL(Inward.Itemcode), Outward.date, Inward.date) AS date, ;
     NVL(Inward.Qantity, 0)  AS Inward, ;
     NVL(Outward.Qantity, 0) AS Outward ;
  FROM Inward ;
  FULL OUTER JOIN Outward on Inward.Itemcode = Outward.Itemcode 

>I have two views
>1. Inward register
> fields itemcode, date, quantity
>2. Outward register
> fields itecode, date, quantity
>
>Iwant to create a third view from the above two which is of format
>
>Stock register
> Fields Itemcode, Date , Inward, Outward.
>
>IS it possible using SQL statement of whould go in for usal programming method
>Rajesh