Orbis Projects invoices conversion.

orbis-projects-invoices-conversion.sql

INSERT 
	INTO 
		orbis_projects_invoices ( project_id, invoice_number )
	SELECT
		project.id,
		project.invoice_number
	FROM
		orbis_projects AS project
			LEFT JOIN
		orbis_projects_invoices AS invoice
				ON project.id = invoice.project_id AND project.invoice_number = invoice.invoice_number
	WHERE
		project.invoice_number IS NOT NULL
			AND
		project.invoice_number != ''
			AND
		invoice.id IS NULL
;