SELECT purchase.*,b.uName,c.budgetCode,c.budgetName,d.pr_satusName,e.unitName
FROM purchase
INNER JOIN (user b,budget c) ON( purchase.uID=b.uID AND purchase.budgetID=c.budgetID)
INNER JOIN (purchase_status d,unit e) ON( purchase.pr_satusID=d.pr_satusID AND purchase.unitID=e.unitID)
ORDER BY purchase.purchaseID DESC