Getting all records from two tables

[Cliff]

I have two tables, patients and transfusions. Not all patients are transfused. I want to create one query that will show all patients, regardless if they were transfused. Also, each patient may have more than 1 transfusion event.

Pat A Tx 1/1/2016
Pat A Tx 1/2/2016
Pat B
Pat C Tx 2/1/2016
Pat D
Pat E Tx 2/1/2016
Pat E Tx 2/3/2016
Pat E Tx 2/5/2013

I can't seem to create a query that will give me all records from both tables. I can only get records for patients that do have transfusions.

Is there a way to get all records from both tables?

Thanks

 

[Ranman256]

you must make an OUTER join. In the query, dbl-click the line joining the 2 tables.
set the option to Show all records in patients.

Then you get your wanted results.

 

[Cliff]

Thanks.

There was a "record deleted" field in each table - they had unique field names, all the fields do. I didn't allow records to be deleted, just changed a 0 to a 1. I set the query to say the patient table = 0 and the tx table = 0, and oddly I couldn't get all of the records. I made each their own query and was bale to get all of the records. Very odd.