SQL join tables at date

SQL join tables at date

I'm looking to join 2 header tables with a date field where "receiptdate"
= "date".
See my current effort so far giving me no output - any ideas on the
correct join mechanism?
! screenshot
In business terms, I am trying to get a view that gives me an output
showing planned production (Plan/Plan_line tables) and achieved production
(Receipt/Reciptline tables).
So in simple terms, I am looking for 4 columns: Date (receiptdate in
receipt and date in plan) Product (APN in receipt_line and style in
plan_line) Quantity Planned (quantity in plan_line) Quantity Achieved
(receiptqty in receiptline)