>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
You can use a FULL OUTER JOIN to combine data from both tables. Use NVL() functions to convert null values (from records that exist in one table, but not in the other) into zeroes.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)