title: KSQL JOIN to return only one result with duplicated Keys
body: <p>I have some KSQL queries running on top of Kafka (currenlty in version 5.52, planning to upgrade to lastest soon).</p>
  <p>Imagine you have 2 streams stream_A, stream_B, but you may have some duplicated id's in stream_B.id (for example some retries the applications has logged).</p>
  <p>When you do something like:</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE STREAM result WITH (KAFKA_TOPIC=&quot;some_topic&quot;) AS
  SELECT stream_A.field, stream_B.field
  FROM stream_A INNER JOIN stream_B on steam_A.id = stream_B.id;
  </code></pre>
  <p>Is there a way to tell KSQL that you only want to get the first one of those matches?</p>