problem with connecting tables

[Smzemke_(Guest)]

Hello-____I^m using SQL Database, and RR v. 10.0.____I^m creating a report that combines data from 2 tables:__Table #1: Sales Orders__Table #2: Purchase Orders____I want this report to print out Sales Orders that are shipping today, and Purchase Orders that are arriving on the same day.____I^ve linked the tables with by the field "Ship Date".____When I print the report, if there isn^t a PO arriving on the specified date, then No records print - not even Sales Order information.____However, if I change the ship date in a PO to today^s date, then when I print the report, it will give me all of the Sales Orders and the Purchase Order info.____So - it seems like if there isn^t a PO for that day - then it won^t print anything. But, if there is a PO for that day - then it^ll print everything.____The master table is the "Companies" table. Each company has a company ID. I^ve linked the sales order to the company table by company_id. And then linked the purchase order table to the sales order table by ship date. If I link the purchase order table to the company table by company id - then nothing prints right. I won^t print all of the sales orders correctly.____I am very confused - please help.____Thanks

[kfleming]

You need to edit the join so that you include unmatched records on the left so that a master file record is still included even when there is no matching record in the related table.____Kathleen__R&R Support