while you weren't looking, Caleb Simonyi-Gindele <[EMAIL PROTECTED]> wrote:
> How do I get it to produce a row even when dat_staff_code is null?
try something like
SELECT coalesce(dat_staff_code, 0)...GROUP BY dat_staff_code
That will substitute a zero for any NULL value in that column, which
G
I
have a SELECT query that basically adds up my sales, removes credit adjustments
(eg. Returns) and gives the net figure.
This
is the query:
SELECT
(SELECT SUM(cli_tran_amount) FROM vetpmardet WHERE cli_credit_adj_trans_no IN
(SELECT sys_tran_number from vetpmardet WHERE cli_tran_trans
