joins and where

[nikko50]

Hi there. Can you use a where clause when you are joining tables? My statement below is not pulling any records.

$getall="select main.equipmentid, sum(receive.quantity) as 'receivedsum', sum(shiplist.quantity) as 'shippedsum' , sum(loan.quantity) as 'loanedsum'
from main WHERE equipmentid= '$equipmentid'
left join receive on main.equipmentid = receive.equipmentid
left join shiplist on main.equipmentid = shiplist.equipmentid
left join loan on main.equipmentid = loan.equipmentid
group by main.equipmentid order";

[drew010]

i think its not working because you have "order" sitting by itself at the end of the query. i assume you mean order by something. its probably just not executing the query successfully.

[nikko50]

Thanks so much. I missed that!