Crystal Reports Joining tables on two condition

Message

Hey
The two SQLs below will give different results, can any one tell me how can implement the first SQL in crystal 

//Joining two tables on two conditions
select si.Code, pqsi.Active
from StockItem si 
left outer join ProductionQuoteStockItem pqsi on si.StockItemId = pqsi.StockItemId 
and pqsi.Active = 1

//joining two table on one condition 
select si.Code, pqsi.Active
from StockItem si 
left outer join ProductionQuoteStockItem pqsi on si.StockItemId = pqsi.StockItemId  
where pqsi.Active = 1

Thanks.