view problem

From: Manash Chakraborty <manash_at_superlink.net>
Date: Wed, 25 Nov 1998 12:29:56 EST
Message-ID: <73heqk$ghc$2@earth.superlink.net>

Hi,

Ihave two tables
 tab1 with col1(number)
tab2 with col2(number)

 Iwant to create a view vw12 with col12(number)  the view column will show only the product of tab1.col1 and tab2.col2.

 such tab1 col1

                    2
                    3
                    4
and tab2 col2
                 10
                  12
                  13

The view I want with column

                                  20
                                  36
                                  52

 Thanks in advance .Tapash Received on Wed Nov 25 1998 - 11:29:56 CST