I have two tables with fields
date, member, value
In the two tables some records mach on member and I subtract the values but there could be a member i one table but not the other and then I want to get that record as well and the value.
Is this possible?
My current sql is like this (not returning all members)
SELECT DATE.a, trade_mbr.a, GA7VAL.a-GA7VAL.b,
FROM clearbuy a, clearsell b
INNER JOIN trade_mbr.a=trade_mbr.b
ORDER BY member.a Asc