Let's say I have this in an access recordset (DAO 3.51):

Code:
'ID  Name       Last Name
'
'0   Robert     Point
'1   Mark       Stuff
'1   Dicky      Other stuff
'2   Freako     Yaddayadda
'2   Gulp       Packa
'2   Spoofy     Blahblah
'3   Frank      Click
'4   Shrink     Doubleclick
And let's say I want to pull out all the names with '2' as ID. What's the SQL statement to do that?