
#use int

drop view if exists v_kontrah_efaktura;
create view v_kontrah_efaktura as 
select distinct 
k.idn,k.symbol, k.nazwa,k.extraA as lista_maili
from opng n,kontrah k
where k.guid=n.kontrguid and n.datawystaw>date_sub(current_date,interval 1 month);

