Database is Access. I am joining two tables called A and B. The name of the field is x. The field is required(in table A) in one table and not required(in table B) in the other. There are no other mandatory fields where i can join the two tables. While running the query it is not picking up the records if the field is left blank in table B. Is there anyway to solve the problem. Thanks in advance.