selecting counts from two different tables

From: Stuart Cracraft <cracraft_at_quaker-oats.ai.mit.edu>
Date: 25 Oct 1994 17:05:45 GMT
Message-ID: <38jdt9INNbe_at_life.ai.mit.edu>

I have two tables "A" and "B". I want to select a distinct count based on one column from A (call it "a") and a count of all rows from B, calculate an average of the latter divided by the former, and output the three values (count of A, count of B, B/A) in a SINGLE ROW.

How can I do this in SQL*Plus?

Please reply to cracraft_at_ai.mit.edu. Received on Tue Oct 25 1994 - 18:05:45 CET

This message: [ Message body ]
Next message: Jacqui Caren: "Re: SQORA.DLL doesn't recognize DBQ parameter?"
Previous message: Steven P. Muench: "Re: Format dates in Forms 4.0"
Next in thread: Lawrence James: "Re: selecting counts from two different tables"
Reply: Lawrence James: "Re: selecting counts from two different tables"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message