Re: [Skunkworks] myDBA gurus

try joins insert into reports select custnum,region,status,invoice,inv_date,price,discount from invoice i inner join vw_use u on i.custnum = i.custnum left join vw_charge c on i.invoice = c.invoice where 1 having invoice is null;