select hp.primary_barcode as barcode, isnull(hp.supp_prod_code,'') as supp_prod_code, hp.description, pl.price as price, pl.cost, cast(v.vat_rate as int) as vat_rate, pl.rrp, null as effective_from, null as valid_to, 'Stoke' as price_list, pl1.price as retail_list from prices_live pl inner join helpproduct hp on hp.product = pl.product inner join vat v on v.vat_code = pl.vat_code --left outer join prices p on p.product = pl.product and p.valid_to > getdate()-1 and p.list_no = 1 left outer join prices_live pl1 on pl1.product = pl.product and pl1.list_no = 1 where pl.list_no = 2 and hp.archive = 0 and hp.company_name like '%Easy Sleep%'