title: Maximum value with multiple select statements
body: <p>Can you please help me to get MAX AuditId(from CheckDetailAddendumA table ) value from the below query.</p>
  
  <pre><code>Select * from CheckDetailAddendumA
  Where BusinessDate = '20041110'
  and AuditID in (select AuditID from payments where paymentid in (select PaymentID from PaymentLinks where BusinessDate = '20041110' and ItemID = 11451163))
  Order by AuditID
  </code></pre>
  
  <p>Thanks in Advance!!!</p>