Join? Union? I am so lost.

[Hank Reardon]

I have 2 tables. One with 20,000 entries the only with a few hundred.
I need to group and order both tables by the dates and SUM the Debits and Credits in each. (FYI settle is a date.)

something like this:

$query = "SELECT proj3_trades.settle, proj3_cash.date,
ROUND(( SUM(sale) - SUM(purch) ),0) as netTrades,
ROUND(( SUM(credit) - SUM(debit) ),0) as netCashFlow
FROM proj3_trades LEFT JOIN proj3_cash
ON proj3_trades.settle = proj3_cash.date
GROUP BY proj3_trades.settle
ORDER BY proj3_trades.settle ASC";

I unfortunately no SQL guru. And if there is one out there - thank you VERY MUCH.
good karma to all.
Cheers.