Someone

SELECT invoice_per_client.invoice_id, invoice_per_client.year, invoice_per_client.invoice_date, invoice_per_client.licensee, invoice_per_client.country, invoice_per_title.running_num, invoice_per_title.item, invoice_per_title.contract_id, invoice_per_title.studio_id, invoice_per_title.category, invoice_per_title.curr, invoice_per_title.amount, invoice_per_title.am_in_us, invoice_per_title.due_date, invoice_per_title.comment, invoice_per_title.link4
FROM invoice_per_client LEFT JOIN invoice_per_title ON invoice_per_client.invoice_id=invoice_per_title.invoice_id
ORDER BY invoice_per_client.record_num, invoice_per_title.running_num;