SELECT a.noakaun, a.namapenyewa, (
SELECT distinct baki
FROM transaksi b
WHERE a.noakaun = b.noakaun
AND jenistrx = 'D'
AND baki > 0.00
AND tarikhtrx < '2007-09-01') as jum46 from penyewa  a where a.noakaun = 'AM0001'


SELECT a.noakaun, a.namapenyewa, (

SELECT b.noakaun,sum( baki )
FROM transaksi b
WHERE jenistrx = 'D'
AND baki > 0.00
AND tarikhtrx <= '2007-10-01'
and a.noakaun = b.noakaun
GROUP BY noakaun
) AS jum46
FROM penyewa a
ORDER BY a.noakaun

SELECT DISTINCT noakaun, sum( baki ) AS jumtunggak
FROM transaksi
WHERE jenistrx = 'D'
AND baki > 0.00
AND tarikhtrx <= '2007-11-01'
GROUP BY noakaun
LIMIT 0 , 30

 SELECT noakaun, (

SELECT b.baki
FROM transaksi b
WHERE b.tarikhtrx > '2007-09-01'
AND b.tarikhtrx <= '2007-11-01'
WHERE a.noakaun = b.noakaun
GROUP BY b.noakaun
) AS jum23, (

SELECT c.baki
FROM transaksi c
WHERE c.tarikhtrx > '2007-07-01'
AND c.tarikhtrx <= '2007-09-01'
WHERE a.noakaun = c.noakaun
GROUP BY c.noakaun
) AS jum46
FROM penyewa a
order by a.noakaun
LIMIT 0 , 30 

SELECT noakaun, sum( baki ) AS tunggakan
FROM `transaksi`
WHERE tarikhtrx <= '2007-10-01'
GROUP BY noakaun
ORDER BY noakaun
LIMIT 0 , 30

SELECT a.noakaun AS akaunsewa, a.namapenyewa, (

SELECT DISTINCT sum( baki )
FROM transaksi b
WHERE jenistrx = 'D'
AND baki > 0.00
AND tarikhtrx <= '2007-10-01'
GROUP BY noakaun = akaunsewa
) AS jum46
FROM penyewa a
ORDER BY a.noakaun

Ini OK...
SELECT noakaun, sum( baki ) AS tunggakan
FROM transaksi b
WHERE jenistrx = 'D'
AND tarikhtrx <= '2007-10-01'
GROUP BY noakaun
LIMIT 0 , 30