Page Comparison

SELECT pi.app_id,sd.field,sd.value ,pi.value last_name FROM apply__personal_sociodemographic_vw sd inner join
apply__personal_information_vw pi on pi.app_id=sd.app_id where sd.field='married_or_rdp'
and pi.field='lastname';