What three records did it bring back? Did they equate to the query criteria?
OR... are they the only three records that have values in the linked table - in which case your join might be incorrect.
Maybe an Inner Join might work better for you?
Its difficult to say exactly without seeing / knowing your database structure.
Cheers
Ian