title: Select inside select not working properly and shows error
body: <p>I have 2 tables: </p>
  
  <pre><code>t_orderPayment with n_id,n_order,n_paytype AND
  t_paytype with n_ID , str_desc
  </code></pre>
  
  <p>My Query is:</p>
  
  <pre><code>SELECT t_OrderPayment.n_order , 
  t_OrderPayment.n_paytype = (select t_paytype.str_desc as n_paytype from t_PayType, t_orderpayment where t_OrderPayment.n_PayType = t_PayType.n_ID)
  FROM t_OrderPayment
  WHERE (((t_OrderPayment.n_PaymentStatus)&lt;&gt;-7)) ;
  </code></pre>
  
  <p>It returns error </p>
  
  <blockquote>
    <p>"At most one record can be returned by this subquery"</p>
  </blockquote>
  
  <p>I tried to set it with MAX and TOP 1 like n_paytype = (select max(t_paytype.str_desc) but shows me error Expr1001
  Str.desc have only text values and this could be the reason. May be INNER JOIN can help me somehow?</p>