I haven’t used a lot of joins outside of inner joins, and so I am looking for some clarification. I have this BAQ set up, and I want to show when there are records in UD100/UD100A that don’t match with the LaborHed data joined to the tables shown. I added some test data in UD100/UD100A, but in the query it only shows the blanks on the UD field. There should be some blanks on the labor head side for the data that I added that doesn’t match a labor hed record, but they don’t show up. Do I need to make the sections sub queries so that I can do a single join?
