MySQL Query

I want a query that does this.

Table structures attached.

I want to query table wo_adjs for all where column "type" = "L", then I want to query table workorder where workorder.wokey = wo_adjs.woid AND workorder.datecompl is between two dates.

I only want to display the wokey (or woid) for the workorders that meet those criteria.

Thanks
table-wo-adjs.jpg
table-workorder.jpg