Home

Request Assistance

%3CLINGO-SUB%20id%3D%22lingo-sub-391296%22%20slang%3D%22en-US%22%3ERequest%20Assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391296%22%20slang%3D%22en-US%22%3EI%20have%20two%20tables%20linked.%20One%20table%20with%20all%20records%20and%20other%20have%20only%20few%20records.%20When%20I%20am%20querying%20only%20linked%20records%20available%20in%20both%20tables%20is%20displayed.%20Records%20held%20in%20only%20one%20table%20with%20no%20related%20records%20in%20second%20table%20is%20not%20displayed.%20Kindly%20assist.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-391296%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2010%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
baiggows
Occasional Visitor
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.
1 Reply
Highlighted
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.