A query that uses an Inner Join (default join type) will return rows ONLY when a row in tblA has a matching row in tblB. If you want all the rows of tblA returned along with any matching data from tblB, you need to change the Join type to Left or Right depending on the table order that you see in QBE view. Left if you want all the rows from the table on the left side of the join. Right if you want all the rows from the table on the right side of the join.