gistfile1.sql

   Select product.brand Brand, drp.Name, drp.Quantity Quantity,drp.CreatedDate,

       from   call, 
		drp , 
		Product2  product	 
   where  drp.IsDeleted == false
	AND call.IsDeleted == false 
   	AND drp.Product == product.ID
	AND drp.Call = call.ID

Select product.brand Brand,product.name, drp.Name,call.account, drp.Quantity Quantity,drp.CreatedDate
from call,
drp ,
Product2 product
where drp.Product == product.ID
AND drp.Call = call.ID