title: How can I concat these two rows in a SQL table?
body: <p>I have the following data in a single table:</p>
  
  <p><a href="https://i.stack.imgur.com/ZRTlA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZRTlA.png" alt="enter image description here"></a></p>
  
  <p>I need a SQL query that can combine the data to append url1 to the batch row and url2 to the single row. Could I use the KNO column to create some sort of matching information?</p>
  
  <p>Result:</p>
  
  <p><a href="https://i.stack.imgur.com/TAj2j.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TAj2j.png" alt="enter image description here"></a></p>