Diplaying results of a query with a one to many relationship

[AshikHusein]

This is a general question.

If I have two tables say A and B with a one to many relationship and if there is no linked record in table B for a record in table A, if you run the query, that particular record does not show up at all.

Is there any way that this record can be shown in the query with no corresponding records in table B in the query (since there is no corresponding record)?

Thanks.

 

[FoFa]

Click on the join line and tell it to use an outer join (all records from tablea and records from Tableb that match)

 

[AshikHusein]

Thanks! That helped greatly!!