insert into M_ProductInfo select NEWID(),a.AnimalName+'-'+p.ProductName,null,cast(a.AnimalCode as varchar(20))+'-'+cast(p.ProductCode as varchar(20)),null,a.AnimalName+'-'+p.ProductName,0,0,null,GETDATE()
from M_AnimalInfo a join M_ProductInfo2 p on 1=1
