I have table called tblTransaction. I have my query such as this
"SELECT * FROM tbltransaction WHERE productID=2715 AND (outletFromID=4 OR outletToID=4) ORDER BY transactionDate,transactionTime,transactionDetailsID". The problem now I want to know is that if outletFromID!=4 and (transactionType='ti'). So if it not from outletFromID=4 then I just want to look for transactionType='ti'. How can I do this? Thank you.