title: A SELECT Query Joining Data From The Same Table
body: <p>The barcode values in the table below exist multiple times for certain transaction types. I'm filtering the data through a SELECT query using one specific transaction type (e.g. 'Input'), but would also like the data from another transaction type that matches with the specific barcodes being pulled through.</p>
  <p>Data:</p>
  <pre><code>| Weight | Barcode | Transaction_Type | Order_No |
  |:------:|:-------:|:----------------:|:--------:|
  | 27.81  | 1111222 | PO               | 101      |
  | 27.81  | 1111222 | Input            | 0        |
  | 22.64  | 1111333 | PO               | 102      |
  | 22.64  | 1111333 | Input            | 0        |
  </code></pre>
  <p>Desired Output:</p>
  <pre><code>| Weight | Barcode | Transaction_Type | Order_No |
  |:------:|:-------:|:----------------:|:--------:|
  | 27.81  | 1111222 | Input            | 101      |
  | 22.64  | 1111333 | Input            | 102      |
  </code></pre>