Remove duplicate records from query of 2 tables
<p>I have the following 2 table:</p>

<p>Table 1 : invoices <br>
invoiceID  clientName<br>
| 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| Tony<br>
| 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| Ludwig<br>
| 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| Ralph<br></p>

<p>Table 2 : invoice_items<br>
invoiceID  itemDescription<br>
| 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| Flat monitor LED etc...<br>
| 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| HP Printer Inkjet etc...<br>
| 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| Laptop wahtever etc...<br></p>

<p>I'm trying to query only the invoices from Table "invoices", but allow the user the search the item descriptions.</p>

<p>I have written </p>

<pre><code>$query = "SELECT i.*, ii.invoiceID, ii.itemDescription from invoices i, invoice_items ii, WHERE ii.itemDescription like "%'.$_GET["s"].'%" AND i.invoiceID = ii.invoiceID";
</code></pre>

<p>but this will results in duplicates. any ideas ?</p>