title: SQL select joined 2 tables same as one column
body: <p>SQL table <code>Authority</code> is:</p>
  
  <pre><code>AuthorNo  Price  PrePay(bit)
  ----------------------------
     1       250$    1
     2       120$    0
     3       300$    0
     4       112$    1
     5       25$     0
  </code></pre>
  
  <p>Table <code>Order</code> is:</p>
  
  <pre><code>AuthorNo  OrderNo
  -----------------
    1         33
    1         34
    2         33
    2         38
    3         41
    3         82
    4         55
    4         21
    5         21
    5         66
  </code></pre>
  
  <p>I want the result is:</p>
  
  <p>Select from <code>Authority.AuthorNo</code> where <code>AuthorNo</code> same in <code>Order.OrderNo</code> and at least one of the <code>AuthorNo.Prepay</code> is 1</p>
  
  <pre><code>AuthorNo
  --------
     1
     2
     4
     5
  </code></pre>
  
  <p>How to select this?</p>