code View

in DREAM 6

select d_person.id_person, id_dream, 
d_status.status, d_person_att.vt12

from d_person 
inner join d_person_att on d_person.id_person = d_person_att.id_person
inner join d_status on d_person.id_person = d_status.id_person
where d_status.domain = 'HIVST' and d_status.active = 1 and d_status.status <> d_person_att.vt12
order by id_dream