I have two tables linked. One table with all records and other have only few records. When I am querying only linked records available in both tables is displayed. Records held in only one table with no related records in second table is not displayed. Kindly assist.
Right click on the line between the tables in the query. Select either 2 or 3 depending on which has all of the rows. Now, you should see all rows with data where it exists.