Lookup query Henk.

lookup-query-henk.sql

SELECT
	t.*,
	d.*
FROM
	(
		SELECT
			`company_code`,
			`company_name` as `CompanyName`,
			`period_start_date` as `Begindatum`,
			`period_end_date` as `Einddatum`,
			`document_code` as `Type_aangifte`,
			`status_description` as `Status`,
			'1c' as `tag_btw_aangifte`,
			COAlESCE( `supplies_to_countries_within_the_ec`, 0 ) as `3b_omzet`,
			COALESCE( `value_added_tax_supplies_services_other_rates`, 0 ) as `bedrag`
		FROM lookup74_wp.wp_lookup_declarations
		WHERE `vat_return_xbrl` > ''
		AND `status` = 'active'
		AND `value_added_tax_supplies_services_other_rates` != 0
		AND `company_code` = '1200'
		AND `period_end_date` = '20190331'
	) d,
	(
		SELECT `office`
		FROM `wp_lookup_transaction_lines`
		WHERE office = '1200'
		GROUP BY `office`
	) t
WHERE
	d.`company_code` = t.`office`
;