SQL

Is it possible to join these two SQL statements without creating a cartesian join?

SELECT fund, SUM(ACTUAL_HRS)

        FROM labor_to_date
        GROUP BY fund;

SELECT  fund, SUM(hours)
        FROM timecard
        WHERE timecard.month = 6
        GROUP BY fund;

"Contracts" is a table you can use which lists all valid "fund" numbers.

Patrick Lanphier Received on Fri Jun 19 1998 - 10:47:05 CDT