Select Statement.... HELP

[TenTwenty]

I have two tables that look more or less like this:

Member:
idMember Name Surname
1 John Watts
2 Pete Pletz
3 Carl Bekker

History
idHistory idMember DataA DataB
1 2 AAAAAAAA BBBBBBBB

All I want is an access select statement that would show me the members that does not have any History entries, thus, members 1 and 3

[si_the_geek]

Questions about SQL statements are generally better in our Database Development forum, as many 'experts' regularly go there - you are lucky that I saw this thread! (I can move the thread there if you want)

A simple sub-query should work nicely...

SELECT idMember, [Name], Surname
FROM Member
WHERE idMember NOT IN (SELECT idMember FROM History GROUP BY idMember)

(the Group By part is only to make it faster - it is basically a 'Distinct')