MySQL Forums
Forum List  »  MySQL Query Browser

Re: SELECT Calculations
Posted by: Sinan Eldem
Date: September 27, 2005 11:22AM

try:

$getWHSE = mysql_query("SELECT ((QtyOnHand + Qty_PO) - (Qty_BO + Qty_SO)) AS AvailQty FROM IS_Qty WHERE AvailQty >= 1 ORDER BY AvailQty DESC LIMIT 1");

Options: ReplyQuote


Subject
Written By
Posted
September 27, 2005 09:12AM
Re: SELECT Calculations
September 27, 2005 11:22AM
September 27, 2005 12:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.