Thanks to everyone in advance

The code below returns the members who have accounts that are inactive, and works correctly.
It returns the memberid, but returns null values for the barcode values.
I am explicitly looking for unmatched rows, i.e. the LEFT OUTER JOIN will return joined member-address
rows which do not have a matching account, according to the ON conditions, and these are the ones I want
because of that WHERE condition.
Therefore account.barcode will always be NULL too.

Is there to perform the same query and return account details?
I have tried running a query to return just the memberid values and then perform a second query to match the account
details, but this is very ineffecient and slow.


select member.memberid, account.barcode
  FROM member
INNER
  JOIN address
    ON address.MemberID = member.Memberid
LEFT OUTER
  JOIN account
    ON account.Memberid = member.MemberID
   AND account.enddate >= current_date
   AND account.closed = 0
 WHERE account.Memberid is null AND member.isDeleted = 0

Special thanks to r937 for help.
James