NewBie : SQL Problem..

From: <ashesh48_at_my-dejanews.com>
Date: Fri, 29 May 1998 13:36:48 GMT
Message-ID: <6kmdlg$to7$1@nnrp1.dejanews.com>

Hi,
  I have a problem with counts.
   I have 3 tables.. wtiht the following no.of rows in it..

     table name             count(rows)
   -------------------           ------------------
        A                                     25
        B                                      5
        C                                     10

Now i want to create another table (D) which can have the following coulumns..
     Columns
       1.  Table name
       2.  Counts.

Out put.. sholud be as follow...
           table name        counts.
          ----------------          ----------
                A                          25
                B                            5
                C                           10

 I am not able to get the query.. for that. Please help...

Thanks in advance for you help..

Ashesh.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 29 1998 - 08:36:48 CDT