colmem: SELECT m.id, m.name, g.name, g.date_str, g.date FROM members AS m, gifts AS g WHERE m.id = g.member