You could also try to

a) fully qualify the column names in the innner query (avoid mixing unqualified and qualified column names in a query)

b) give the column a dedicated alias (member_id_table.MemberID as memberid)