tags.sql

select mrfr1.record, mrfr1.tag, mrfr1.subfield, 
  substring(mrfr1.value from 0 for 20), mrfr2.subfield, 
  substring(mrfr2.value from 0 for 20) 
from metabib.real_full_rec mrfr1 
join metabib.real_full_rec mrfr2 on mrfr2.record = mrfr1.record 
where mrfr1.subfield = 'a' and mrfr2.subfield = 'b' 
  and mrfr1.tag = '245' and mrfr2.tag = '245' order by mrfr1.record;