VIEW

CREATE  VIEW beste AS 
SELECT 
    a.woz,
    b.wijk AS wijk,
	a.plaats AS plaats,
	a.straat AS straat,
	a.nr AS nr,
	b.soc AS soortobject,
	e.bouwjaar, 
	a.waarde AS waarde,
	b.groep AS groep,
	d.datum AS datum,
	d.vkc AS vkc,
	d.aard AS aard
FROM 
	stuf20 a,
	stuf21 b,
	stuf53 c,
	stuf52 d, 
	stuf22 e
WHERE
	a.woz = b.woz 
AND 
	c.woz = b.woz
AND
	a.woz=RIGHT(e.woz,11)
AND
	c.volgnr = d.volgnr 
AND
	d.datum <>''
AND
	e.cod LIKE('11%')
ORDER BY
	a.plaats,
	a.straat,
	a.nr