I have a simple (and incorrect queuer) that gives the wrong answer.
Can someone show me the correct syntax?
t
"select sum(s.ref), r.value, s.ref from registry as s
left join referralkey as r on (s.ref = r.cd)
group by s.ref, r.value order by r.value, s.ref"sum | value | ref
------+-----------------+-----3462 | A Friend | 3 150 | Bridal Guide | 6 33 | Coupon | 11
yet qs "select count(*) from registry where ref =3"count = 1154 qs "select count(*) from registry where ref=6"
count = 25 qs "select count(*) from registry where ref=11"
count = 3
thanks
--
Arthur R. Van Hook
hook@lake-lotawana.mo.us
avanhook3@comcast.net
(816) 578-4704 - Home
(816) 629-0071 Cell