Page 1 of 1

[resolved] JOINS

Posted: Wed Apr 21, 2004 6:45 pm
by 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";